﻿<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="ACHDataSet" targetNamespace="http://tempuri.org/ACHDataSet.xsd" xmlns:mstns="http://tempuri.org/ACHDataSet.xsd" xmlns="http://tempuri.org/ACHDataSet.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="ACHConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="ACHConnectionString (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.ACH.Properties.Settings.GlobalReference.Default.ACHConnectionString" Provider="System.Data.SqlClient" />
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="AddressesTableAdapter" GeneratorDataComponentClassName="AddressesTableAdapter" Name="Addresses" UserDataComponentName="AddressesTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ACHConnectionString (Settings)" DbObjectName="ACH.dbo.Addresses" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[Addresses] WHERE (([ID] = @Original_ID) AND ((@IsNull_Description = 1 AND [Description] IS NULL) OR ([Description] = @Original_Description)) AND ((@IsNull_Street = 1 AND [Street] IS NULL) OR ([Street] = @Original_Street)) AND ((@IsNull_Street2 = 1 AND [Street2] IS NULL) OR ([Street2] = @Original_Street2)) AND ((@IsNull_Zip = 1 AND [Zip] IS NULL) OR ([Zip] = @Original_Zip)) AND ([Location] = @Original_Location) AND ([Country] = @Original_Country) AND ((@IsNull_Phone1 = 1 AND [Phone1] IS NULL) OR ([Phone1] = @Original_Phone1)) AND ((@IsNull_Phone2 = 1 AND [Phone2] IS NULL) OR ([Phone2] = @Original_Phone2)) AND ((@IsNull_EMail = 1 AND [EMail] IS NULL) OR ([EMail] = @Original_EMail)) AND ((@IsNull_Website = 1 AND [Website] IS NULL) OR ([Website] = @Original_Website)) AND ((@IsNull_AdditionalInformation = 1 AND [AdditionalInformation] IS NULL) OR ([AdditionalInformation] = @Original_AdditionalInformation)) AND ([CreateDate] = @Original_CreateDate) AND ([UpdateDate] = @Original_UpdateDate) AND ([UpdateUser] = @Original_UpdateUser) AND ([CreateUser] = @Original_CreateUser))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Description" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Description" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Description" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Description" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Street" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Street" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Street" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Street" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Street2" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Street2" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Street2" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Street2" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Zip" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Zip" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Zip" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Zip" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Location" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Location" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Country" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Country" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Phone1" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Phone1" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Phone1" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Phone1" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Phone2" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Phone2" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Phone2" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Phone2" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_EMail" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="EMail" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_EMail" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="EMail" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Website" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Website" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Website" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Website" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_AdditionalInformation" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="AdditionalInformation" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_AdditionalInformation" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="AdditionalInformation" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_CreateDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="CreateDate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_UpdateDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="UpdateDate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_UpdateUser" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="UpdateUser" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_CreateUser" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="CreateUser" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Addresses] ([ID], [Description], [Street], [Street2], [Zip], [Location], [Country], [Phone1], [Phone2], [EMail], [Website], [AdditionalInformation], [CreateDate], [UpdateDate], [UpdateUser], [CreateUser]) VALUES (@ID, @Description, @Street, @Street2, @Zip, @Location, @Country, @Phone1, @Phone2, @EMail, @Website, @AdditionalInformation, @CreateDate, @UpdateDate, @UpdateUser, @CreateUser);
SELECT ID, Description, Street, Street2, Zip, Location, Country, Phone1, Phone2, EMail, Website, AdditionalInformation, CreateDate, UpdateDate, UpdateUser, CreateUser FROM Addresses WHERE (ID = @ID) ORDER BY Description</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Description" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Description" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Street" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Street" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Street2" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Street2" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Zip" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Zip" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Location" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Location" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Country" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Country" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Phone1" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Phone1" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Phone2" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Phone2" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@EMail" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="EMail" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Website" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Website" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@AdditionalInformation" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="AdditionalInformation" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@CreateDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="CreateDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@UpdateDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="UpdateDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@UpdateUser" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="UpdateUser" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@CreateUser" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="CreateUser" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT ID, Description, Street, Street2, Zip, Location, Country, Phone1, Phone2, EMail, Website, AdditionalInformation, CreateDate, UpdateDate, UpdateUser, CreateUser FROM dbo.Addresses
order by description</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Addresses] SET [ID] = @ID, [Description] = @Description, [Street] = @Street, [Street2] = @Street2, [Zip] = @Zip, [Location] = @Location, [Country] = @Country, [Phone1] = @Phone1, [Phone2] = @Phone2, [EMail] = @EMail, [Website] = @Website, [AdditionalInformation] = @AdditionalInformation, [CreateDate] = @CreateDate, [UpdateDate] = @UpdateDate, [UpdateUser] = @UpdateUser, [CreateUser] = @CreateUser WHERE (([ID] = @Original_ID) AND ((@IsNull_Description = 1 AND [Description] IS NULL) OR ([Description] = @Original_Description)) AND ((@IsNull_Street = 1 AND [Street] IS NULL) OR ([Street] = @Original_Street)) AND ((@IsNull_Street2 = 1 AND [Street2] IS NULL) OR ([Street2] = @Original_Street2)) AND ((@IsNull_Zip = 1 AND [Zip] IS NULL) OR ([Zip] = @Original_Zip)) AND ([Location] = @Original_Location) AND ([Country] = @Original_Country) AND ((@IsNull_Phone1 = 1 AND [Phone1] IS NULL) OR ([Phone1] = @Original_Phone1)) AND ((@IsNull_Phone2 = 1 AND [Phone2] IS NULL) OR ([Phone2] = @Original_Phone2)) AND ((@IsNull_EMail = 1 AND [EMail] IS NULL) OR ([EMail] = @Original_EMail)) AND ((@IsNull_Website = 1 AND [Website] IS NULL) OR ([Website] = @Original_Website)) AND ((@IsNull_AdditionalInformation = 1 AND [AdditionalInformation] IS NULL) OR ([AdditionalInformation] = @Original_AdditionalInformation)) AND ([CreateDate] = @Original_CreateDate) AND ([UpdateDate] = @Original_UpdateDate) AND ([UpdateUser] = @Original_UpdateUser) AND ([CreateUser] = @Original_CreateUser));
SELECT ID, Description, Street, Street2, Zip, Location, Country, Phone1, Phone2, EMail, Website, AdditionalInformation, CreateDate, UpdateDate, UpdateUser, CreateUser FROM Addresses WHERE (ID = @ID) ORDER BY Description</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Description" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Description" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Street" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Street" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Street2" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Street2" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Zip" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Zip" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Location" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Location" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Country" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Country" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Phone1" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Phone1" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Phone2" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Phone2" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@EMail" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="EMail" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Website" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Website" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@AdditionalInformation" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="AdditionalInformation" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@CreateDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="CreateDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@UpdateDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="UpdateDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@UpdateUser" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="UpdateUser" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@CreateUser" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="CreateUser" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Description" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Description" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Description" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Description" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Street" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Street" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Street" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Street" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Street2" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Street2" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Street2" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Street2" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Zip" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Zip" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Zip" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Zip" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Location" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Location" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Country" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Country" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Phone1" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Phone1" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Phone1" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Phone1" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Phone2" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Phone2" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Phone2" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Phone2" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_EMail" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="EMail" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_EMail" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="EMail" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Website" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Website" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Website" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Website" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_AdditionalInformation" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="AdditionalInformation" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_AdditionalInformation" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="AdditionalInformation" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_CreateDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="CreateDate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_UpdateDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="UpdateDate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_UpdateUser" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="UpdateUser" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_CreateUser" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="CreateUser" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ID" DataSetColumn="ID" />
              <Mapping SourceColumn="Description" DataSetColumn="Description" />
              <Mapping SourceColumn="Street" DataSetColumn="Street" />
              <Mapping SourceColumn="Street2" DataSetColumn="Street2" />
              <Mapping SourceColumn="Zip" DataSetColumn="Zip" />
              <Mapping SourceColumn="Location" DataSetColumn="Location" />
              <Mapping SourceColumn="Country" DataSetColumn="Country" />
              <Mapping SourceColumn="Phone1" DataSetColumn="Phone1" />
              <Mapping SourceColumn="Phone2" DataSetColumn="Phone2" />
              <Mapping SourceColumn="EMail" DataSetColumn="EMail" />
              <Mapping SourceColumn="Website" DataSetColumn="Website" />
              <Mapping SourceColumn="AdditionalInformation" DataSetColumn="AdditionalInformation" />
              <Mapping SourceColumn="CreateDate" DataSetColumn="CreateDate" />
              <Mapping SourceColumn="UpdateDate" DataSetColumn="UpdateDate" />
              <Mapping SourceColumn="UpdateUser" DataSetColumn="UpdateUser" />
              <Mapping SourceColumn="CreateUser" DataSetColumn="CreateUser" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="LocationsTableAdapter" GeneratorDataComponentClassName="LocationsTableAdapter" Name="Locations" UserDataComponentName="LocationsTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ACHConnectionString (Settings)" DbObjectName="ACH.dbo.Locations" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[Locations] WHERE (([ID] = @Original_ID) AND ((@IsNull_Description = 1 AND [Description] IS NULL) OR ([Description] = @Original_Description)) AND ([Name] = @Original_Name) AND ([Lodging_ID] = @Original_Lodging_ID) AND ((@IsNull_AdditionalInformation = 1 AND [AdditionalInformation] IS NULL) OR ([AdditionalInformation] = @Original_AdditionalInformation)) AND ([CreateDate] = @Original_CreateDate) AND ([UpdateDate] = @Original_UpdateDate) AND ([UpdateUser] = @Original_UpdateUser) AND ([CreateUser] = @Original_CreateUser))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Description" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Description" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Description" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Description" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Lodging_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Lodging_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_AdditionalInformation" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="AdditionalInformation" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_AdditionalInformation" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="AdditionalInformation" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_CreateDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="CreateDate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_UpdateDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="UpdateDate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_UpdateUser" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="UpdateUser" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_CreateUser" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="CreateUser" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Locations] ([ID], [Description], [Name], [Lodging_ID], [AdditionalInformation], [CreateDate], [UpdateDate], [UpdateUser], [CreateUser]) VALUES (@ID, @Description, @Name, @Lodging_ID, @AdditionalInformation, @CreateDate, @UpdateDate, @UpdateUser, @CreateUser);
SELECT ID, Description, Name, Lodging_ID, AdditionalInformation, CreateDate, UpdateDate, UpdateUser, CreateUser FROM Locations WHERE (ID = @ID) ORDER BY Name</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Description" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Description" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Lodging_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Lodging_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@AdditionalInformation" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="AdditionalInformation" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@CreateDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="CreateDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@UpdateDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="UpdateDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@UpdateUser" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="UpdateUser" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@CreateUser" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="CreateUser" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT ID, Description, Name, Lodging_ID, AdditionalInformation, CreateDate, UpdateDate, UpdateUser, CreateUser FROM dbo.Locations
order by name</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Locations] SET [ID] = @ID, [Description] = @Description, [Name] = @Name, [Lodging_ID] = @Lodging_ID, [AdditionalInformation] = @AdditionalInformation, [CreateDate] = @CreateDate, [UpdateDate] = @UpdateDate, [UpdateUser] = @UpdateUser, [CreateUser] = @CreateUser WHERE (([ID] = @Original_ID) AND ((@IsNull_Description = 1 AND [Description] IS NULL) OR ([Description] = @Original_Description)) AND ([Name] = @Original_Name) AND ([Lodging_ID] = @Original_Lodging_ID) AND ((@IsNull_AdditionalInformation = 1 AND [AdditionalInformation] IS NULL) OR ([AdditionalInformation] = @Original_AdditionalInformation)) AND ([CreateDate] = @Original_CreateDate) AND ([UpdateDate] = @Original_UpdateDate) AND ([UpdateUser] = @Original_UpdateUser) AND ([CreateUser] = @Original_CreateUser));
SELECT ID, Description, Name, Lodging_ID, AdditionalInformation, CreateDate, UpdateDate, UpdateUser, CreateUser FROM Locations WHERE (ID = @ID) ORDER BY Name</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Description" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Description" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Lodging_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Lodging_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@AdditionalInformation" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="AdditionalInformation" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@CreateDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="CreateDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@UpdateDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="UpdateDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@UpdateUser" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="UpdateUser" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@CreateUser" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="CreateUser" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Description" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Description" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Description" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Description" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Lodging_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Lodging_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_AdditionalInformation" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="AdditionalInformation" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_AdditionalInformation" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="AdditionalInformation" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_CreateDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="CreateDate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_UpdateDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="UpdateDate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_UpdateUser" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="UpdateUser" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_CreateUser" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="CreateUser" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ID" DataSetColumn="ID" />
              <Mapping SourceColumn="Description" DataSetColumn="Description" />
              <Mapping SourceColumn="Name" DataSetColumn="Name" />
              <Mapping SourceColumn="Lodging_ID" DataSetColumn="Lodging_ID" />
              <Mapping SourceColumn="AdditionalInformation" DataSetColumn="AdditionalInformation" />
              <Mapping SourceColumn="CreateDate" DataSetColumn="CreateDate" />
              <Mapping SourceColumn="UpdateDate" DataSetColumn="UpdateDate" />
              <Mapping SourceColumn="UpdateUser" DataSetColumn="UpdateUser" />
              <Mapping SourceColumn="CreateUser" DataSetColumn="CreateUser" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="LodgingRoomsTableAdapter" GeneratorDataComponentClassName="LodgingRoomsTableAdapter" Name="LodgingRooms" UserDataComponentName="LodgingRoomsTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ACHConnectionString (Settings)" DbObjectName="ACH.dbo.LodgingRooms" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[LodgingRooms] WHERE (([ID] = @Original_ID) AND ((@IsNull_Description = 1 AND [Description] IS NULL) OR ([Description] = @Original_Description)) AND ([Name] = @Original_Name) AND ([Lodging_ID] = @Original_Lodging_ID) AND ([RoomType_ID] = @Original_RoomType_ID) AND ([CreateDate] = @Original_CreateDate) AND ([UpdateDate] = @Original_UpdateDate) AND ([UpdateUser] = @Original_UpdateUser) AND ([CreateUser] = @Original_CreateUser))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Description" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Description" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Description" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Description" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Lodging_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Lodging_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_RoomType_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="RoomType_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_CreateDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="CreateDate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_UpdateDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="UpdateDate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_UpdateUser" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="UpdateUser" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_CreateUser" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="CreateUser" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[LodgingRooms] ([ID], [Description], [Name], [Lodging_ID], [RoomType_ID], [CreateDate], [UpdateDate], [UpdateUser], [CreateUser]) VALUES (@ID, @Description, @Name, @Lodging_ID, @RoomType_ID, @CreateDate, @UpdateDate, @UpdateUser, @CreateUser);
SELECT ID, Description, Name, Lodging_ID, RoomType_ID, CreateDate, UpdateDate, UpdateUser, CreateUser FROM LodgingRooms WHERE (ID = @ID) ORDER BY Name</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Description" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Description" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Lodging_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Lodging_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@RoomType_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="RoomType_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@CreateDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="CreateDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@UpdateDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="UpdateDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@UpdateUser" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="UpdateUser" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@CreateUser" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="CreateUser" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT ID, Description, Name, Lodging_ID, RoomType_ID, CreateDate, UpdateDate, UpdateUser, CreateUser FROM dbo.LodgingRooms
order by name</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[LodgingRooms] SET [ID] = @ID, [Description] = @Description, [Name] = @Name, [Lodging_ID] = @Lodging_ID, [RoomType_ID] = @RoomType_ID, [CreateDate] = @CreateDate, [UpdateDate] = @UpdateDate, [UpdateUser] = @UpdateUser, [CreateUser] = @CreateUser WHERE (([ID] = @Original_ID) AND ((@IsNull_Description = 1 AND [Description] IS NULL) OR ([Description] = @Original_Description)) AND ([Name] = @Original_Name) AND ([Lodging_ID] = @Original_Lodging_ID) AND ([RoomType_ID] = @Original_RoomType_ID) AND ([CreateDate] = @Original_CreateDate) AND ([UpdateDate] = @Original_UpdateDate) AND ([UpdateUser] = @Original_UpdateUser) AND ([CreateUser] = @Original_CreateUser));
SELECT ID, Description, Name, Lodging_ID, RoomType_ID, CreateDate, UpdateDate, UpdateUser, CreateUser FROM LodgingRooms WHERE (ID = @ID) ORDER BY Name</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Description" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Description" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Lodging_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Lodging_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@RoomType_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="RoomType_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@CreateDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="CreateDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@UpdateDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="UpdateDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@UpdateUser" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="UpdateUser" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@CreateUser" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="CreateUser" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Description" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Description" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Description" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Description" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Lodging_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Lodging_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_RoomType_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="RoomType_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_CreateDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="CreateDate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_UpdateDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="UpdateDate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_UpdateUser" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="UpdateUser" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_CreateUser" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="CreateUser" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ID" DataSetColumn="ID" />
              <Mapping SourceColumn="Description" DataSetColumn="Description" />
              <Mapping SourceColumn="Name" DataSetColumn="Name" />
              <Mapping SourceColumn="Lodging_ID" DataSetColumn="Lodging_ID" />
              <Mapping SourceColumn="RoomType_ID" DataSetColumn="RoomType_ID" />
              <Mapping SourceColumn="CreateDate" DataSetColumn="CreateDate" />
              <Mapping SourceColumn="UpdateDate" DataSetColumn="UpdateDate" />
              <Mapping SourceColumn="UpdateUser" DataSetColumn="UpdateUser" />
              <Mapping SourceColumn="CreateUser" DataSetColumn="CreateUser" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="ACHConnectionString (Settings)" DbObjectType="Unknown" FillMethodModifier="Public" FillMethodName="FillRoomOccupancy" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataRoomOccupancy" GeneratorSourceName="FillRoomOccupancy" GetMethodModifier="Public" GetMethodName="GetDataRoomOccupancy" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataRoomOccupancy" UserSourceName="FillRoomOccupancy">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        LodgingRooms.ID, LodgingRooms.Description, LodgingRooms.Name, LodgingRooms.Lodging_ID, LodgingRooms.RoomType_ID, LodgingRooms.CreateDate, 
                         LodgingRooms.UpdateDate, LodgingRooms.UpdateUser, LodgingRooms.CreateUser, RoomTypes.NoOfBeds
FROM            LodgingRooms INNER JOIN
                         RoomTypes ON LodgingRooms.RoomType_ID = RoomTypes.ID
where Lodgingrooms.lodging_ID = @Lodging
ORDER BY LodgingRooms.Name</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="Lodging" ColumnName="Lodging_ID" DataSourceName="ACH.dbo.LodgingRooms" DataTypeServer="varchar(40)" DbType="AnsiString" Direction="Input" ParameterName="@Lodging" Precision="0" ProviderType="VarChar" Scale="0" Size="40" SourceColumn="Lodging_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="LodgingsTableAdapter" GeneratorDataComponentClassName="LodgingsTableAdapter" Name="Lodgings" UserDataComponentName="LodgingsTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ACHConnectionString (Settings)" DbObjectName="ACH.dbo.Lodgings" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[Lodgings] WHERE (([ID] = @Original_ID) AND ([Name] = @Original_Name) AND ([Address_ID] = @Original_Address_ID) AND ((@IsNull_AdditionalInformation = 1 AND [AdditionalInformation] IS NULL) OR ([AdditionalInformation] = @Original_AdditionalInformation)) AND ([CreateDate] = @Original_CreateDate) AND ([UpdateDate] = @Original_UpdateDate) AND ([UpdateUser] = @Original_UpdateUser) AND ([CreateUser] = @Original_CreateUser))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Address_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Address_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_AdditionalInformation" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="AdditionalInformation" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_AdditionalInformation" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="AdditionalInformation" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_CreateDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="CreateDate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_UpdateDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="UpdateDate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_UpdateUser" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="UpdateUser" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_CreateUser" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="CreateUser" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Lodgings] ([ID], [Name], [Address_ID], [AdditionalInformation], [CreateDate], [UpdateDate], [UpdateUser], [CreateUser]) VALUES (@ID, @Name, @Address_ID, @AdditionalInformation, @CreateDate, @UpdateDate, @UpdateUser, @CreateUser);
SELECT ID, Name, Address_ID, AdditionalInformation, CreateDate, UpdateDate, UpdateUser, CreateUser FROM Lodgings WHERE (ID = @ID) ORDER BY Name</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Address_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Address_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@AdditionalInformation" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="AdditionalInformation" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@CreateDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="CreateDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@UpdateDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="UpdateDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@UpdateUser" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="UpdateUser" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@CreateUser" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="CreateUser" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT ID, Name, Address_ID, AdditionalInformation, CreateDate, UpdateDate, UpdateUser, CreateUser FROM dbo.Lodgings
order by name</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Lodgings] SET [ID] = @ID, [Name] = @Name, [Address_ID] = @Address_ID, [AdditionalInformation] = @AdditionalInformation, [CreateDate] = @CreateDate, [UpdateDate] = @UpdateDate, [UpdateUser] = @UpdateUser, [CreateUser] = @CreateUser WHERE (([ID] = @Original_ID) AND ([Name] = @Original_Name) AND ([Address_ID] = @Original_Address_ID) AND ((@IsNull_AdditionalInformation = 1 AND [AdditionalInformation] IS NULL) OR ([AdditionalInformation] = @Original_AdditionalInformation)) AND ([CreateDate] = @Original_CreateDate) AND ([UpdateDate] = @Original_UpdateDate) AND ([UpdateUser] = @Original_UpdateUser) AND ([CreateUser] = @Original_CreateUser));
SELECT ID, Name, Address_ID, AdditionalInformation, CreateDate, UpdateDate, UpdateUser, CreateUser FROM Lodgings WHERE (ID = @ID) ORDER BY Name</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Address_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Address_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@AdditionalInformation" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="AdditionalInformation" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@CreateDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="CreateDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@UpdateDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="UpdateDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@UpdateUser" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="UpdateUser" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@CreateUser" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="CreateUser" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Address_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Address_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_AdditionalInformation" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="AdditionalInformation" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_AdditionalInformation" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="AdditionalInformation" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_CreateDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="CreateDate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_UpdateDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="UpdateDate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_UpdateUser" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="UpdateUser" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_CreateUser" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="CreateUser" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ID" DataSetColumn="ID" />
              <Mapping SourceColumn="Name" DataSetColumn="Name" />
              <Mapping SourceColumn="Address_ID" DataSetColumn="Address_ID" />
              <Mapping SourceColumn="AdditionalInformation" DataSetColumn="AdditionalInformation" />
              <Mapping SourceColumn="CreateDate" DataSetColumn="CreateDate" />
              <Mapping SourceColumn="UpdateDate" DataSetColumn="UpdateDate" />
              <Mapping SourceColumn="UpdateUser" DataSetColumn="UpdateUser" />
              <Mapping SourceColumn="CreateUser" DataSetColumn="CreateUser" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="MembersTableAdapter" GeneratorDataComponentClassName="MembersTableAdapter" Name="Members" UserDataComponentName="MembersTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ACHConnectionString (Settings)" DbObjectName="ACH.dbo.Members" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[Members] WHERE (([ID] = @Original_ID) AND ([Name] = @Original_Name) AND ([Code] = @Original_Code) AND ([Usable] = @Original_Usable) AND ((@IsNull_Address_ID = 1 AND [Address_ID] IS NULL) OR ([Address_ID] = @Original_Address_ID)) AND ((@IsNull_EMail = 1 AND [EMail] IS NULL) OR ([EMail] = @Original_EMail)) AND ([PositionType_ID] = @Original_PositionType_ID) AND ((@IsNull_MobilePhone = 1 AND [MobilePhone] IS NULL) OR ([MobilePhone] = @Original_MobilePhone)) AND ((@IsNull_Phone = 1 AND [Phone] IS NULL) OR ([Phone] = @Original_Phone)) AND ((@IsNull_Fax = 1 AND [Fax] IS NULL) OR ([Fax] = @Original_Fax)) AND ([CreateDate] = @Original_CreateDate) AND ([UpdateDate] = @Original_UpdateDate) AND ([UpdateUser] = @Original_UpdateUser) AND ([CreateUser] = @Original_CreateUser))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_Code" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="Code" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_Usable" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Usable" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Address_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Address_ID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Address_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Address_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_EMail" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="EMail" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_EMail" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="EMail" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_PositionType_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="PositionType_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_MobilePhone" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="MobilePhone" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_MobilePhone" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="MobilePhone" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Phone" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Phone" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Phone" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Phone" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Fax" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Fax" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Fax" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Fax" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_CreateDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="CreateDate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_UpdateDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="UpdateDate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_UpdateUser" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="UpdateUser" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_CreateUser" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="CreateUser" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Members] ([ID], [Name], [Code], [Usable], [Address_ID], [EMail], [PositionType_ID], [MobilePhone], [Phone], [Fax], [CreateDate], [UpdateDate], [UpdateUser], [CreateUser]) VALUES (@ID, @Name, @Code, @Usable, @Address_ID, @EMail, @PositionType_ID, @MobilePhone, @Phone, @Fax, @CreateDate, @UpdateDate, @UpdateUser, @CreateUser);
SELECT ID, Name, Code, Usable, Address_ID, EMail, PositionType_ID, MobilePhone, Phone, Fax, CreateDate, UpdateDate, UpdateUser, CreateUser FROM Members WHERE (ID = @ID) ORDER BY Name</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Code" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="Code" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Usable" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Usable" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Address_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Address_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@EMail" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="EMail" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@PositionType_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="PositionType_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@MobilePhone" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="MobilePhone" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Phone" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Phone" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Fax" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Fax" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@CreateDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="CreateDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@UpdateDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="UpdateDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@UpdateUser" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="UpdateUser" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@CreateUser" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="CreateUser" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT ID, Name, Code, Usable, Address_ID, EMail, PositionType_ID, MobilePhone, Phone, Fax, CreateDate, UpdateDate, UpdateUser, CreateUser FROM dbo.Members
order by name</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Members] SET [ID] = @ID, [Name] = @Name, [Code] = @Code, [Usable] = @Usable, [Address_ID] = @Address_ID, [EMail] = @EMail, [PositionType_ID] = @PositionType_ID, [MobilePhone] = @MobilePhone, [Phone] = @Phone, [Fax] = @Fax, [CreateDate] = @CreateDate, [UpdateDate] = @UpdateDate, [UpdateUser] = @UpdateUser, [CreateUser] = @CreateUser WHERE (([ID] = @Original_ID) AND ([Name] = @Original_Name) AND ([Code] = @Original_Code) AND ([Usable] = @Original_Usable) AND ((@IsNull_Address_ID = 1 AND [Address_ID] IS NULL) OR ([Address_ID] = @Original_Address_ID)) AND ((@IsNull_EMail = 1 AND [EMail] IS NULL) OR ([EMail] = @Original_EMail)) AND ([PositionType_ID] = @Original_PositionType_ID) AND ((@IsNull_MobilePhone = 1 AND [MobilePhone] IS NULL) OR ([MobilePhone] = @Original_MobilePhone)) AND ((@IsNull_Phone = 1 AND [Phone] IS NULL) OR ([Phone] = @Original_Phone)) AND ((@IsNull_Fax = 1 AND [Fax] IS NULL) OR ([Fax] = @Original_Fax)) AND ([CreateDate] = @Original_CreateDate) AND ([UpdateDate] = @Original_UpdateDate) AND ([UpdateUser] = @Original_UpdateUser) AND ([CreateUser] = @Original_CreateUser));
SELECT ID, Name, Code, Usable, Address_ID, EMail, PositionType_ID, MobilePhone, Phone, Fax, CreateDate, UpdateDate, UpdateUser, CreateUser FROM Members WHERE (ID = @ID) ORDER BY Name</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Code" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="Code" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Usable" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Usable" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Address_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Address_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@EMail" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="EMail" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@PositionType_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="PositionType_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@MobilePhone" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="MobilePhone" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Phone" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Phone" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Fax" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Fax" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@CreateDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="CreateDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@UpdateDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="UpdateDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@UpdateUser" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="UpdateUser" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@CreateUser" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="CreateUser" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_Code" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="Code" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_Usable" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Usable" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Address_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Address_ID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Address_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Address_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_EMail" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="EMail" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_EMail" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="EMail" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_PositionType_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="PositionType_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_MobilePhone" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="MobilePhone" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_MobilePhone" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="MobilePhone" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Phone" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Phone" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Phone" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Phone" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Fax" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Fax" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Fax" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Fax" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_CreateDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="CreateDate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_UpdateDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="UpdateDate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_UpdateUser" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="UpdateUser" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_CreateUser" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="CreateUser" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ID" DataSetColumn="ID" />
              <Mapping SourceColumn="Name" DataSetColumn="Name" />
              <Mapping SourceColumn="Code" DataSetColumn="Code" />
              <Mapping SourceColumn="Usable" DataSetColumn="Usable" />
              <Mapping SourceColumn="Address_ID" DataSetColumn="Address_ID" />
              <Mapping SourceColumn="EMail" DataSetColumn="EMail" />
              <Mapping SourceColumn="PositionType_ID" DataSetColumn="PositionType_ID" />
              <Mapping SourceColumn="MobilePhone" DataSetColumn="MobilePhone" />
              <Mapping SourceColumn="Phone" DataSetColumn="Phone" />
              <Mapping SourceColumn="Fax" DataSetColumn="Fax" />
              <Mapping SourceColumn="CreateDate" DataSetColumn="CreateDate" />
              <Mapping SourceColumn="UpdateDate" DataSetColumn="UpdateDate" />
              <Mapping SourceColumn="UpdateUser" DataSetColumn="UpdateUser" />
              <Mapping SourceColumn="CreateUser" DataSetColumn="CreateUser" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="PositionTypesTableAdapter" GeneratorDataComponentClassName="PositionTypesTableAdapter" Name="PositionTypes" UserDataComponentName="PositionTypesTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ACHConnectionString (Settings)" DbObjectName="ACH.dbo.PositionTypes" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[PositionTypes] WHERE (([ID] = @Original_ID) AND ([Name] = @Original_Name) AND ([CreateDate] = @Original_CreateDate) AND ([UpdateDate] = @Original_UpdateDate) AND ([UpdateUser] = @Original_UpdateUser) AND ([CreateUser] = @Original_CreateUser))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_CreateDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="CreateDate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_UpdateDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="UpdateDate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_UpdateUser" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="UpdateUser" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_CreateUser" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="CreateUser" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[PositionTypes] ([ID], [Name], [Duties], [CreateDate], [UpdateDate], [UpdateUser], [CreateUser]) VALUES (@ID, @Name, @Duties, @CreateDate, @UpdateDate, @UpdateUser, @CreateUser);
SELECT ID, Name, Duties, CreateDate, UpdateDate, UpdateUser, CreateUser FROM PositionTypes WHERE (ID = @ID) ORDER BY Name</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Duties" Precision="0" ProviderType="Text" Scale="0" Size="0" SourceColumn="Duties" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@CreateDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="CreateDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@UpdateDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="UpdateDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@UpdateUser" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="UpdateUser" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@CreateUser" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="CreateUser" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT ID, Name, Duties, CreateDate, UpdateDate, UpdateUser, CreateUser FROM dbo.PositionTypes
order by name</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[PositionTypes] SET [ID] = @ID, [Name] = @Name, [Duties] = @Duties, [CreateDate] = @CreateDate, [UpdateDate] = @UpdateDate, [UpdateUser] = @UpdateUser, [CreateUser] = @CreateUser WHERE (([ID] = @Original_ID) AND ([Name] = @Original_Name) AND ([CreateDate] = @Original_CreateDate) AND ([UpdateDate] = @Original_UpdateDate) AND ([UpdateUser] = @Original_UpdateUser) AND ([CreateUser] = @Original_CreateUser));
SELECT ID, Name, Duties, CreateDate, UpdateDate, UpdateUser, CreateUser FROM PositionTypes WHERE (ID = @ID) ORDER BY Name</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Duties" Precision="0" ProviderType="Text" Scale="0" Size="0" SourceColumn="Duties" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@CreateDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="CreateDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@UpdateDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="UpdateDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@UpdateUser" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="UpdateUser" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@CreateUser" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="CreateUser" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_CreateDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="CreateDate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_UpdateDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="UpdateDate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_UpdateUser" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="UpdateUser" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_CreateUser" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="CreateUser" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ID" DataSetColumn="ID" />
              <Mapping SourceColumn="Name" DataSetColumn="Name" />
              <Mapping SourceColumn="Duties" DataSetColumn="Duties" />
              <Mapping SourceColumn="CreateDate" DataSetColumn="CreateDate" />
              <Mapping SourceColumn="UpdateDate" DataSetColumn="UpdateDate" />
              <Mapping SourceColumn="UpdateUser" DataSetColumn="UpdateUser" />
              <Mapping SourceColumn="CreateUser" DataSetColumn="CreateUser" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="ACHConnectionString (Settings)" DbObjectName="ACH.dbo.PositionTypes" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillBy" GenerateMethods="Fill" GenerateShortCommands="true" GeneratorSourceName="FillBy" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="FillBy">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT CreateDate, CreateUser, Duties, ID, Name, UpdateDate, UpdateUser FROM PositionTypes ORDER BY Name</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="RoomTypesTableAdapter" GeneratorDataComponentClassName="RoomTypesTableAdapter" Name="RoomTypes" UserDataComponentName="RoomTypesTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ACHConnectionString (Settings)" DbObjectName="ACH.dbo.RoomTypes" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[RoomTypes] WHERE (([ID] = @Original_ID) AND ([NoOfBeds] = @Original_NoOfBeds) AND ([PricePerBedKid] = @Original_PricePerBedKid) AND ([PricePerBedAdult] = @Original_PricePerBedAdult) AND ([PricePerBedGuestKid] = @Original_PricePerBedGuestKid) AND ([PricePerBedGuestAdult] = @Original_PricePerBedGuestAdult) AND ([CreateDate] = @Original_CreateDate) AND ([UpdateDate] = @Original_UpdateDate) AND ([UpdateUser] = @Original_UpdateUser) AND ([CreateUser] = @Original_CreateUser) AND ((@IsNull_PricePerBedTrainer = 1 AND [PricePerBedTrainer] IS NULL) OR ([PricePerBedTrainer] = @Original_PricePerBedTrainer)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_NoOfBeds" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="NoOfBeds" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_PricePerBedKid" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PricePerBedKid" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_PricePerBedAdult" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PricePerBedAdult" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_PricePerBedGuestKid" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PricePerBedGuestKid" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_PricePerBedGuestAdult" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PricePerBedGuestAdult" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_CreateDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="CreateDate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_UpdateDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="UpdateDate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_UpdateUser" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="UpdateUser" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_CreateUser" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="CreateUser" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_PricePerBedTrainer" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PricePerBedTrainer" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_PricePerBedTrainer" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PricePerBedTrainer" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[RoomTypes] ([ID], [NoOfBeds], [PricePerBedKid], [PricePerBedAdult], [PricePerBedGuestKid], [PricePerBedGuestAdult], [CreateDate], [UpdateDate], [UpdateUser], [CreateUser], [PricePerBedTrainer]) VALUES (@ID, @NoOfBeds, @PricePerBedKid, @PricePerBedAdult, @PricePerBedGuestKid, @PricePerBedGuestAdult, @CreateDate, @UpdateDate, @UpdateUser, @CreateUser, @PricePerBedTrainer);
SELECT ID, NoOfBeds, PricePerBedKid, PricePerBedAdult, PricePerBedGuestKid, PricePerBedGuestAdult, CreateDate, UpdateDate, UpdateUser, CreateUser, PricePerBedTrainer FROM RoomTypes WHERE (ID = @ID) ORDER BY NoOfBeds</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@NoOfBeds" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="NoOfBeds" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@PricePerBedKid" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PricePerBedKid" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@PricePerBedAdult" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PricePerBedAdult" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@PricePerBedGuestKid" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PricePerBedGuestKid" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@PricePerBedGuestAdult" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PricePerBedGuestAdult" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@CreateDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="CreateDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@UpdateDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="UpdateDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@UpdateUser" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="UpdateUser" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@CreateUser" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="CreateUser" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@PricePerBedTrainer" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PricePerBedTrainer" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT ID, NoOfBeds, PricePerBedKid, PricePerBedAdult, PricePerBedGuestKid, PricePerBedGuestAdult, CreateDate, UpdateDate, UpdateUser, CreateUser, PricePerBedTrainer FROM dbo.RoomTypes
order by noofbeds</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[RoomTypes] SET [ID] = @ID, [NoOfBeds] = @NoOfBeds, [PricePerBedKid] = @PricePerBedKid, [PricePerBedAdult] = @PricePerBedAdult, [PricePerBedGuestKid] = @PricePerBedGuestKid, [PricePerBedGuestAdult] = @PricePerBedGuestAdult, [CreateDate] = @CreateDate, [UpdateDate] = @UpdateDate, [UpdateUser] = @UpdateUser, [CreateUser] = @CreateUser, [PricePerBedTrainer] = @PricePerBedTrainer WHERE (([ID] = @Original_ID) AND ([NoOfBeds] = @Original_NoOfBeds) AND ([PricePerBedKid] = @Original_PricePerBedKid) AND ([PricePerBedAdult] = @Original_PricePerBedAdult) AND ([PricePerBedGuestKid] = @Original_PricePerBedGuestKid) AND ([PricePerBedGuestAdult] = @Original_PricePerBedGuestAdult) AND ([CreateDate] = @Original_CreateDate) AND ([UpdateDate] = @Original_UpdateDate) AND ([UpdateUser] = @Original_UpdateUser) AND ([CreateUser] = @Original_CreateUser) AND ((@IsNull_PricePerBedTrainer = 1 AND [PricePerBedTrainer] IS NULL) OR ([PricePerBedTrainer] = @Original_PricePerBedTrainer)));
SELECT ID, NoOfBeds, PricePerBedKid, PricePerBedAdult, PricePerBedGuestKid, PricePerBedGuestAdult, CreateDate, UpdateDate, UpdateUser, CreateUser, PricePerBedTrainer FROM RoomTypes WHERE (ID = @ID) ORDER BY NoOfBeds</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@NoOfBeds" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="NoOfBeds" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@PricePerBedKid" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PricePerBedKid" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@PricePerBedAdult" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PricePerBedAdult" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@PricePerBedGuestKid" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PricePerBedGuestKid" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@PricePerBedGuestAdult" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PricePerBedGuestAdult" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@CreateDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="CreateDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@UpdateDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="UpdateDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@UpdateUser" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="UpdateUser" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@CreateUser" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="CreateUser" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@PricePerBedTrainer" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PricePerBedTrainer" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_NoOfBeds" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="NoOfBeds" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_PricePerBedKid" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PricePerBedKid" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_PricePerBedAdult" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PricePerBedAdult" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_PricePerBedGuestKid" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PricePerBedGuestKid" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_PricePerBedGuestAdult" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PricePerBedGuestAdult" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_CreateDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="CreateDate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_UpdateDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="UpdateDate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_UpdateUser" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="UpdateUser" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_CreateUser" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="CreateUser" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_PricePerBedTrainer" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PricePerBedTrainer" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_PricePerBedTrainer" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PricePerBedTrainer" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ID" DataSetColumn="ID" />
              <Mapping SourceColumn="NoOfBeds" DataSetColumn="NoOfBeds" />
              <Mapping SourceColumn="PricePerBedKid" DataSetColumn="PricePerBedKid" />
              <Mapping SourceColumn="PricePerBedAdult" DataSetColumn="PricePerBedAdult" />
              <Mapping SourceColumn="PricePerBedGuestKid" DataSetColumn="PricePerBedGuestKid" />
              <Mapping SourceColumn="PricePerBedGuestAdult" DataSetColumn="PricePerBedGuestAdult" />
              <Mapping SourceColumn="CreateDate" DataSetColumn="CreateDate" />
              <Mapping SourceColumn="UpdateDate" DataSetColumn="UpdateDate" />
              <Mapping SourceColumn="UpdateUser" DataSetColumn="UpdateUser" />
              <Mapping SourceColumn="CreateUser" DataSetColumn="CreateUser" />
              <Mapping SourceColumn="PricePerBedTrainer" DataSetColumn="PricePerBedTrainer" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="TrainingParticipantPositionsTableAdapter" GeneratorDataComponentClassName="TrainingParticipantPositionsTableAdapter" Name="TrainingParticipantPositions" UserDataComponentName="TrainingParticipantPositionsTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ACHConnectionString (Settings)" DbObjectName="ACH.dbo.TrainingParticipantPositions" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[TrainingParticipantPositions] WHERE (([ID] = @Original_ID) AND ([Name] = @Original_Name) AND ([CreateDate] = @Original_CreateDate) AND ([UpdateDate] = @Original_UpdateDate) AND ([UpdateUser] = @Original_UpdateUser) AND ([CreateUser] = @Original_CreateUser))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_CreateDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="CreateDate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_UpdateDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="UpdateDate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_UpdateUser" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="UpdateUser" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_CreateUser" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="CreateUser" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[TrainingParticipantPositions] ([ID], [Name], [Duties], [CreateDate], [UpdateDate], [UpdateUser], [CreateUser]) VALUES (@ID, @Name, @Duties, @CreateDate, @UpdateDate, @UpdateUser, @CreateUser);
SELECT ID, Name, Duties, CreateDate, UpdateDate, UpdateUser, CreateUser FROM TrainingParticipantPositions WHERE (ID = @ID) ORDER BY Name</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Duties" Precision="0" ProviderType="Text" Scale="0" Size="0" SourceColumn="Duties" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@CreateDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="CreateDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@UpdateDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="UpdateDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@UpdateUser" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="UpdateUser" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@CreateUser" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="CreateUser" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT ID, Name, Duties, CreateDate, UpdateDate, UpdateUser, CreateUser FROM dbo.TrainingParticipantPositions
order by name</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[TrainingParticipantPositions] SET [ID] = @ID, [Name] = @Name, [Duties] = @Duties, [CreateDate] = @CreateDate, [UpdateDate] = @UpdateDate, [UpdateUser] = @UpdateUser, [CreateUser] = @CreateUser WHERE (([ID] = @Original_ID) AND ([Name] = @Original_Name) AND ([CreateDate] = @Original_CreateDate) AND ([UpdateDate] = @Original_UpdateDate) AND ([UpdateUser] = @Original_UpdateUser) AND ([CreateUser] = @Original_CreateUser));
SELECT ID, Name, Duties, CreateDate, UpdateDate, UpdateUser, CreateUser FROM TrainingParticipantPositions WHERE (ID = @ID) ORDER BY Name</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Duties" Precision="0" ProviderType="Text" Scale="0" Size="0" SourceColumn="Duties" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@CreateDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="CreateDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@UpdateDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="UpdateDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@UpdateUser" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="UpdateUser" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@CreateUser" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="CreateUser" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_CreateDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="CreateDate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_UpdateDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="UpdateDate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_UpdateUser" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="UpdateUser" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_CreateUser" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="CreateUser" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ID" DataSetColumn="ID" />
              <Mapping SourceColumn="Name" DataSetColumn="Name" />
              <Mapping SourceColumn="Duties" DataSetColumn="Duties" />
              <Mapping SourceColumn="CreateDate" DataSetColumn="CreateDate" />
              <Mapping SourceColumn="UpdateDate" DataSetColumn="UpdateDate" />
              <Mapping SourceColumn="UpdateUser" DataSetColumn="UpdateUser" />
              <Mapping SourceColumn="CreateUser" DataSetColumn="CreateUser" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="TrainingParticipantsTableAdapter" GeneratorDataComponentClassName="TrainingParticipantsTableAdapter" Name="TrainingParticipants" UserDataComponentName="TrainingParticipantsTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ACHConnectionString (Settings)" DbObjectType="Unknown" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[TrainingParticipants] WHERE (([ID] = @Original_ID) AND ([Training_ID] = @Original_Training_ID) AND ([Member_ID] = @Original_Member_ID) AND ([Position_ID] = @Original_Position_ID) AND ([StartDate] = @Original_StartDate) AND ([EndDate] = @Original_EndDate) AND ([CreateDate] = @Original_CreateDate) AND ([UpdateDate] = @Original_UpdateDate) AND ([UpdateUser] = @Original_UpdateUser) AND ([CreateUser] = @Original_CreateUser))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Training_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Training_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Member_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Member_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Position_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Position_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_StartDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="StartDate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_EndDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="EndDate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_CreateDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="CreateDate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_UpdateDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="UpdateDate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_UpdateUser" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="UpdateUser" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_CreateUser" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="CreateUser" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[TrainingParticipants] ([ID], [Training_ID], [Member_ID], [Position_ID], [StartDate], [EndDate], [CreateDate], [UpdateDate], [UpdateUser], [CreateUser]) VALUES (@ID, @Training_ID, @Member_ID, @Position_ID, @StartDate, @EndDate, @CreateDate, @UpdateDate, @UpdateUser, @CreateUser);
SELECT ID, Training_ID, Member_ID, Position_ID, StartDate, EndDate, CreateDate, UpdateDate, UpdateUser, CreateUser FROM TrainingParticipants WHERE (Member_ID = @Member_ID) AND (Position_ID = @Position_ID) AND (Training_ID = @Training_ID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Training_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Training_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Member_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Member_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Position_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Position_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@StartDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="StartDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@EndDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="EndDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@CreateDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="CreateDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@UpdateDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="UpdateDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@UpdateUser" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="UpdateUser" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@CreateUser" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="CreateUser" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT        lr.Name AS room_name, tro.LodgingRoom_ID AS Room_ID, tro.StartDate, tro.EndDate, t.ID, Trainings.Name AS Training_Name, t.Training_ID, t.Member_ID, 
                         t.Position_ID, t.StartDate AS Expr1, t.EndDate AS Expr2, t.CreateDate, t.UpdateDate, t.UpdateUser, t.CreateUser
FROM            TrainingParticipants AS t LEFT OUTER JOIN
                         TrainingRoomOccupancies AS tro ON t.ID = tro.TrainingParticipant_ID LEFT OUTER JOIN
                         LodgingRooms AS lr ON tro.LodgingRoom_ID = lr.ID INNER JOIN
                         Trainings ON Trainings.ID = t.Training_ID</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[TrainingParticipants] SET [ID] = @ID, [Training_ID] = @Training_ID, [Member_ID] = @Member_ID, [Position_ID] = @Position_ID, [StartDate] = @StartDate, [EndDate] = @EndDate, [CreateDate] = @CreateDate, [UpdateDate] = @UpdateDate, [UpdateUser] = @UpdateUser, [CreateUser] = @CreateUser WHERE (([ID] = @Original_ID) AND ([Training_ID] = @Original_Training_ID) AND ([Member_ID] = @Original_Member_ID) AND ([Position_ID] = @Original_Position_ID) AND ([StartDate] = @Original_StartDate) AND ([EndDate] = @Original_EndDate) AND ([CreateDate] = @Original_CreateDate) AND ([UpdateDate] = @Original_UpdateDate) AND ([UpdateUser] = @Original_UpdateUser) AND ([CreateUser] = @Original_CreateUser));
SELECT ID, Training_ID, Member_ID, Position_ID, StartDate, EndDate, CreateDate, UpdateDate, UpdateUser, CreateUser FROM TrainingParticipants WHERE (Member_ID = @Member_ID) AND (Position_ID = @Position_ID) AND (Training_ID = @Training_ID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Training_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Training_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Member_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Member_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Position_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Position_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@StartDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="StartDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@EndDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="EndDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@CreateDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="CreateDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@UpdateDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="UpdateDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@UpdateUser" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="UpdateUser" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@CreateUser" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="CreateUser" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Training_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Training_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Member_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Member_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Position_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Position_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_StartDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="StartDate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_EndDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="EndDate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_CreateDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="CreateDate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_UpdateDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="UpdateDate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_UpdateUser" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="UpdateUser" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_CreateUser" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="CreateUser" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ID" DataSetColumn="ID" />
              <Mapping SourceColumn="Training_ID" DataSetColumn="Training_ID" />
              <Mapping SourceColumn="Member_ID" DataSetColumn="Member_ID" />
              <Mapping SourceColumn="Position_ID" DataSetColumn="Position_ID" />
              <Mapping SourceColumn="StartDate" DataSetColumn="StartDate" />
              <Mapping SourceColumn="EndDate" DataSetColumn="EndDate" />
              <Mapping SourceColumn="CreateDate" DataSetColumn="CreateDate" />
              <Mapping SourceColumn="UpdateDate" DataSetColumn="UpdateDate" />
              <Mapping SourceColumn="UpdateUser" DataSetColumn="UpdateUser" />
              <Mapping SourceColumn="CreateUser" DataSetColumn="CreateUser" />
              <Mapping SourceColumn="Room_ID" DataSetColumn="Room_ID" />
              <Mapping SourceColumn="room_name" DataSetColumn="room_name" />
              <Mapping SourceColumn="Expr1" DataSetColumn="Expr1" />
              <Mapping SourceColumn="Expr2" DataSetColumn="Expr2" />
              <Mapping SourceColumn="Training_Name" DataSetColumn="Training_Name" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="ACHConnectionString (Settings)" DbObjectType="Unknown" FillMethodModifier="Public" FillMethodName="FillTest" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetTest" GeneratorSourceName="FillTest" GetMethodModifier="Public" GetMethodName="GetTest" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetTest" UserSourceName="FillTest">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        1 AS [Check], tp.Training_ID, tp.Member_ID, T.Name AS Training_Name, m.Name AS Member_Name
FROM            Trainings AS T INNER JOIN
                         TrainingParticipants AS tp ON T.ID = tp.Training_ID INNER JOIN
                         Members AS m ON m.ID = tp.Member_ID
where tp.training_id = @Parameter1</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="Parameter1" ColumnName="Training_ID" DataSourceName="ACH.dbo.TrainingParticipants" DataTypeServer="varchar(40)" DbType="AnsiString" Direction="Input" ParameterName="@Parameter1" Precision="0" ProviderType="VarChar" Scale="0" Size="40" SourceColumn="Training_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="TrainingsTableAdapter" GeneratorDataComponentClassName="TrainingsTableAdapter" Name="Trainings" UserDataComponentName="TrainingsTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ACHConnectionString (Settings)" DbObjectName="ACH.dbo.Trainings" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[Trainings] WHERE (([ID] = @Original_ID) AND ([Name] = @Original_Name) AND ([StartDate] = @Original_StartDate) AND ([EndDate] = @Original_EndDate) AND ([Location_ID] = @Original_Location_ID) AND ((@IsNull_TrainingType_ID = 1 AND [TrainingType_ID] IS NULL) OR ([TrainingType_ID] = @Original_TrainingType_ID)) AND ([CreateDate] = @Original_CreateDate) AND ([UpdateDate] = @Original_UpdateDate) AND ([UpdateUser] = @Original_UpdateUser) AND ([CreateUser] = @Original_CreateUser))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_StartDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="StartDate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_EndDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="EndDate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Location_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Location_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_TrainingType_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TrainingType_ID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_TrainingType_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="TrainingType_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_CreateDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="CreateDate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_UpdateDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="UpdateDate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_UpdateUser" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="UpdateUser" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_CreateUser" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="CreateUser" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Trainings] ([ID], [Name], [StartDate], [EndDate], [Location_ID], [TrainingType_ID], [CreateDate], [UpdateDate], [UpdateUser], [CreateUser]) VALUES (@ID, @Name, @StartDate, @EndDate, @Location_ID, @TrainingType_ID, @CreateDate, @UpdateDate, @UpdateUser, @CreateUser);
SELECT ID, Name, StartDate, EndDate, Location_ID, TrainingType_ID, CreateDate, UpdateDate, UpdateUser, CreateUser FROM Trainings WHERE (ID = @ID) ORDER BY StartDate</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@StartDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="StartDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@EndDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="EndDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Location_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Location_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@TrainingType_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="TrainingType_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@CreateDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="CreateDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@UpdateDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="UpdateDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@UpdateUser" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="UpdateUser" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@CreateUser" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="CreateUser" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT ID, Name, StartDate, EndDate, Location_ID, TrainingType_ID, CreateDate, UpdateDate, UpdateUser, CreateUser FROM dbo.Trainings
Order by startdate</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Trainings] SET [ID] = @ID, [Name] = @Name, [StartDate] = @StartDate, [EndDate] = @EndDate, [Location_ID] = @Location_ID, [TrainingType_ID] = @TrainingType_ID, [CreateDate] = @CreateDate, [UpdateDate] = @UpdateDate, [UpdateUser] = @UpdateUser, [CreateUser] = @CreateUser WHERE (([ID] = @Original_ID) AND ([Name] = @Original_Name) AND ([StartDate] = @Original_StartDate) AND ([EndDate] = @Original_EndDate) AND ([Location_ID] = @Original_Location_ID) AND ((@IsNull_TrainingType_ID = 1 AND [TrainingType_ID] IS NULL) OR ([TrainingType_ID] = @Original_TrainingType_ID)) AND ([CreateDate] = @Original_CreateDate) AND ([UpdateDate] = @Original_UpdateDate) AND ([UpdateUser] = @Original_UpdateUser) AND ([CreateUser] = @Original_CreateUser));
SELECT ID, Name, StartDate, EndDate, Location_ID, TrainingType_ID, CreateDate, UpdateDate, UpdateUser, CreateUser FROM Trainings WHERE (ID = @ID) ORDER BY StartDate</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@StartDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="StartDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@EndDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="EndDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Location_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Location_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@TrainingType_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="TrainingType_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@CreateDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="CreateDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@UpdateDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="UpdateDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@UpdateUser" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="UpdateUser" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@CreateUser" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="CreateUser" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_StartDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="StartDate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_EndDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="EndDate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Location_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Location_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_TrainingType_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TrainingType_ID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_TrainingType_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="TrainingType_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_CreateDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="CreateDate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_UpdateDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="UpdateDate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_UpdateUser" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="UpdateUser" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_CreateUser" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="CreateUser" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ID" DataSetColumn="ID" />
              <Mapping SourceColumn="Name" DataSetColumn="Name" />
              <Mapping SourceColumn="StartDate" DataSetColumn="StartDate" />
              <Mapping SourceColumn="EndDate" DataSetColumn="EndDate" />
              <Mapping SourceColumn="Location_ID" DataSetColumn="Location_ID" />
              <Mapping SourceColumn="TrainingType_ID" DataSetColumn="TrainingType_ID" />
              <Mapping SourceColumn="CreateDate" DataSetColumn="CreateDate" />
              <Mapping SourceColumn="UpdateDate" DataSetColumn="UpdateDate" />
              <Mapping SourceColumn="UpdateUser" DataSetColumn="UpdateUser" />
              <Mapping SourceColumn="CreateUser" DataSetColumn="CreateUser" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="TrainingTypesTableAdapter" GeneratorDataComponentClassName="TrainingTypesTableAdapter" Name="TrainingTypes" UserDataComponentName="TrainingTypesTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ACHConnectionString (Settings)" DbObjectName="ACH.dbo.TrainingTypes" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[TrainingTypes] WHERE (([ID] = @Original_ID) AND ([Name] = @Original_Name) AND ([CreateDate] = @Original_CreateDate) AND ([UpdateDate] = @Original_UpdateDate) AND ([UpdateUser] = @Original_UpdateUser) AND ([CreateUser] = @Original_CreateUser))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_CreateDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="CreateDate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_UpdateDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="UpdateDate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_UpdateUser" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="UpdateUser" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_CreateUser" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="CreateUser" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[TrainingTypes] ([ID], [Name], [Description], [CreateDate], [UpdateDate], [UpdateUser], [CreateUser]) VALUES (@ID, @Name, @Description, @CreateDate, @UpdateDate, @UpdateUser, @CreateUser);
SELECT ID, Name, Description, CreateDate, UpdateDate, UpdateUser, CreateUser FROM TrainingTypes WHERE (ID = @ID) ORDER BY Name</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Description" Precision="0" ProviderType="Text" Scale="0" Size="0" SourceColumn="Description" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@CreateDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="CreateDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@UpdateDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="UpdateDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@UpdateUser" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="UpdateUser" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@CreateUser" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="CreateUser" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT ID, Name, Description, CreateDate, UpdateDate, UpdateUser, CreateUser FROM dbo.TrainingTypes
order by name</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[TrainingTypes] SET [ID] = @ID, [Name] = @Name, [Description] = @Description, [CreateDate] = @CreateDate, [UpdateDate] = @UpdateDate, [UpdateUser] = @UpdateUser, [CreateUser] = @CreateUser WHERE (([ID] = @Original_ID) AND ([Name] = @Original_Name) AND ([CreateDate] = @Original_CreateDate) AND ([UpdateDate] = @Original_UpdateDate) AND ([UpdateUser] = @Original_UpdateUser) AND ([CreateUser] = @Original_CreateUser));
SELECT ID, Name, Description, CreateDate, UpdateDate, UpdateUser, CreateUser FROM TrainingTypes WHERE (ID = @ID) ORDER BY Name</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Description" Precision="0" ProviderType="Text" Scale="0" Size="0" SourceColumn="Description" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@CreateDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="CreateDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@UpdateDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="UpdateDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@UpdateUser" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="UpdateUser" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@CreateUser" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="CreateUser" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_CreateDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="CreateDate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_UpdateDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="UpdateDate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_UpdateUser" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="UpdateUser" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_CreateUser" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="CreateUser" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ID" DataSetColumn="ID" />
              <Mapping SourceColumn="Name" DataSetColumn="Name" />
              <Mapping SourceColumn="Description" DataSetColumn="Description" />
              <Mapping SourceColumn="CreateDate" DataSetColumn="CreateDate" />
              <Mapping SourceColumn="UpdateDate" DataSetColumn="UpdateDate" />
              <Mapping SourceColumn="UpdateUser" DataSetColumn="UpdateUser" />
              <Mapping SourceColumn="CreateUser" DataSetColumn="CreateUser" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ExpensesTableAdapter" GeneratorDataComponentClassName="ExpensesTableAdapter" Name="Expenses" UserDataComponentName="ExpensesTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ACHConnectionString (Settings)" DbObjectName="ACH.dbo.Expenses" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [Expenses] WHERE (([ID] = @Original_ID) AND ([Type] = @Original_Type) AND ([Value] = @Original_Value) AND ([CreateDate] = @Original_CreateDate) AND ([UpdateDate] = @Original_UpdateDate) AND ([UpdateUser] = @Original_UpdateUser) AND ([CreateUser] = @Original_CreateUser))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Type" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Type" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_Value" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="Value" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_CreateDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="CreateDate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_UpdateDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="UpdateDate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_UpdateUser" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="UpdateUser" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_CreateUser" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="CreateUser" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [Expenses] ([ID], [Type], [Value], [CreateDate], [UpdateDate], [UpdateUser], [CreateUser]) VALUES (@ID, @Type, @Value, @CreateDate, @UpdateDate, @UpdateUser, @CreateUser);
SELECT ID, Type, Value, CreateDate, UpdateDate, UpdateUser, CreateUser FROM Expenses WHERE (ID = @ID) ORDER BY Type</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Type" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Type" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Value" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="Value" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@CreateDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="CreateDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@UpdateDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="UpdateDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@UpdateUser" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="UpdateUser" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@CreateUser" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="CreateUser" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        ID, Type, Value, CreateDate, UpdateDate, UpdateUser, CreateUser
FROM            Expenses
order by type</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [Expenses] SET [ID] = @ID, [Type] = @Type, [Value] = @Value, [CreateDate] = @CreateDate, [UpdateDate] = @UpdateDate, [UpdateUser] = @UpdateUser, [CreateUser] = @CreateUser WHERE (([ID] = @Original_ID) AND ([Type] = @Original_Type) AND ([Value] = @Original_Value) AND ([CreateDate] = @Original_CreateDate) AND ([UpdateDate] = @Original_UpdateDate) AND ([UpdateUser] = @Original_UpdateUser) AND ([CreateUser] = @Original_CreateUser));
SELECT ID, Type, Value, CreateDate, UpdateDate, UpdateUser, CreateUser FROM Expenses WHERE (ID = @ID) ORDER BY Type</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Type" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Type" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Value" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="Value" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@CreateDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="CreateDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@UpdateDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="UpdateDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@UpdateUser" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="UpdateUser" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@CreateUser" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="CreateUser" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Type" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Type" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_Value" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="Value" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_CreateDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="CreateDate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_UpdateDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="UpdateDate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_UpdateUser" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="UpdateUser" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_CreateUser" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="CreateUser" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ID" DataSetColumn="ID" />
              <Mapping SourceColumn="Type" DataSetColumn="Type" />
              <Mapping SourceColumn="Value" DataSetColumn="Value" />
              <Mapping SourceColumn="CreateDate" DataSetColumn="CreateDate" />
              <Mapping SourceColumn="UpdateDate" DataSetColumn="UpdateDate" />
              <Mapping SourceColumn="UpdateUser" DataSetColumn="UpdateUser" />
              <Mapping SourceColumn="CreateUser" DataSetColumn="CreateUser" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="TrainingParticipants_ExpensesTableAdapter" GeneratorDataComponentClassName="TrainingParticipants_ExpensesTableAdapter" Name="TrainingParticipants_Expenses" UserDataComponentName="TrainingParticipants_ExpensesTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ACHConnectionString (Settings)" DbObjectName="ACH.dbo.TrainingParticipants_Expenses" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [TrainingParticipants_Expenses] WHERE (([ID] = @Original_ID) AND ([TrainingParticipant_ID] = @Original_TrainingParticipant_ID) AND ([Expense_ID] = @Original_Expense_ID) AND ([CreateDate] = @Original_CreateDate) AND ([UpdateDate] = @Original_UpdateDate) AND ([UpdateUser] = @Original_UpdateUser) AND ([CreateUser] = @Original_CreateUser))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_TrainingParticipant_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="TrainingParticipant_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Expense_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Expense_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_CreateDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="CreateDate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_UpdateDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="UpdateDate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_UpdateUser" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="UpdateUser" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_CreateUser" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="CreateUser" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [TrainingParticipants_Expenses] ([ID], [TrainingParticipant_ID], [Expense_ID], [CreateDate], [UpdateDate], [UpdateUser], [CreateUser]) VALUES (@ID, @TrainingParticipant_ID, @Expense_ID, @CreateDate, @UpdateDate, @UpdateUser, @CreateUser);
SELECT ID, TrainingParticipant_ID, Expense_ID, CreateDate, UpdateDate, UpdateUser, CreateUser FROM TrainingParticipants_Expenses WHERE (Expense_ID = @Expense_ID) AND (TrainingParticipant_ID = @TrainingParticipant_ID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@TrainingParticipant_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="TrainingParticipant_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Expense_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Expense_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@CreateDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="CreateDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@UpdateDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="UpdateDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@UpdateUser" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="UpdateUser" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@CreateUser" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="CreateUser" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        ID, TrainingParticipant_ID, Expense_ID, CreateDate, UpdateDate, UpdateUser, CreateUser
FROM            TrainingParticipants_Expenses</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [TrainingParticipants_Expenses] SET [ID] = @ID, [TrainingParticipant_ID] = @TrainingParticipant_ID, [Expense_ID] = @Expense_ID, [CreateDate] = @CreateDate, [UpdateDate] = @UpdateDate, [UpdateUser] = @UpdateUser, [CreateUser] = @CreateUser WHERE (([ID] = @Original_ID) AND ([TrainingParticipant_ID] = @Original_TrainingParticipant_ID) AND ([Expense_ID] = @Original_Expense_ID) AND ([CreateDate] = @Original_CreateDate) AND ([UpdateDate] = @Original_UpdateDate) AND ([UpdateUser] = @Original_UpdateUser) AND ([CreateUser] = @Original_CreateUser));
SELECT ID, TrainingParticipant_ID, Expense_ID, CreateDate, UpdateDate, UpdateUser, CreateUser FROM TrainingParticipants_Expenses WHERE (Expense_ID = @Expense_ID) AND (TrainingParticipant_ID = @TrainingParticipant_ID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@TrainingParticipant_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="TrainingParticipant_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Expense_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Expense_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@CreateDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="CreateDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@UpdateDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="UpdateDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@UpdateUser" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="UpdateUser" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@CreateUser" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="CreateUser" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_TrainingParticipant_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="TrainingParticipant_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Expense_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Expense_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_CreateDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="CreateDate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_UpdateDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="UpdateDate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_UpdateUser" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="UpdateUser" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_CreateUser" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="CreateUser" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ID" DataSetColumn="ID" />
              <Mapping SourceColumn="TrainingParticipant_ID" DataSetColumn="TrainingParticipant_ID" />
              <Mapping SourceColumn="CreateDate" DataSetColumn="CreateDate" />
              <Mapping SourceColumn="UpdateDate" DataSetColumn="UpdateDate" />
              <Mapping SourceColumn="UpdateUser" DataSetColumn="UpdateUser" />
              <Mapping SourceColumn="CreateUser" DataSetColumn="CreateUser" />
              <Mapping SourceColumn="Expense_ID" DataSetColumn="Expense_ID" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="TrainingRoomOccupanciesTableAdapter" GeneratorDataComponentClassName="TrainingRoomOccupanciesTableAdapter" Name="TrainingRoomOccupancies" UserDataComponentName="TrainingRoomOccupanciesTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ACHConnectionString (Settings)" DbObjectName="ACH.dbo.TrainingRoomOccupancies" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [TrainingRoomOccupancies] WHERE (([ID] = @Original_ID) AND ([TrainingParticipant_ID] = @Original_TrainingParticipant_ID) AND ([LodgingRoom_ID] = @Original_LodgingRoom_ID) AND ([StartDate] = @Original_StartDate) AND ([EndDate] = @Original_EndDate) AND ([CreateDate] = @Original_CreateDate) AND ([UpdateDate] = @Original_UpdateDate) AND ([UpdateUser] = @Original_UpdateUser) AND ([CreateUser] = @Original_CreateUser))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_TrainingParticipant_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="TrainingParticipant_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_LodgingRoom_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="LodgingRoom_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_StartDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="StartDate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_EndDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="EndDate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_CreateDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="CreateDate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_UpdateDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="UpdateDate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_UpdateUser" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="UpdateUser" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_CreateUser" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="CreateUser" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [TrainingRoomOccupancies] ([ID], [TrainingParticipant_ID], [LodgingRoom_ID], [StartDate], [EndDate], [CreateDate], [UpdateDate], [UpdateUser], [CreateUser]) VALUES (@ID, @TrainingParticipant_ID, @LodgingRoom_ID, @StartDate, @EndDate, @CreateDate, @UpdateDate, @UpdateUser, @CreateUser);
SELECT ID, TrainingParticipant_ID, LodgingRoom_ID, StartDate, EndDate, CreateDate, UpdateDate, UpdateUser, CreateUser FROM TrainingRoomOccupancies WHERE (LodgingRoom_ID = @LodgingRoom_ID) AND (TrainingParticipant_ID = @TrainingParticipant_ID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@TrainingParticipant_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="TrainingParticipant_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@LodgingRoom_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="LodgingRoom_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@StartDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="StartDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@EndDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="EndDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@CreateDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="CreateDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@UpdateDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="UpdateDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@UpdateUser" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="UpdateUser" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@CreateUser" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="CreateUser" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        ID, TrainingParticipant_ID, LodgingRoom_ID, StartDate, EndDate, CreateDate, UpdateDate, UpdateUser, CreateUser
FROM            TrainingRoomOccupancies</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [TrainingRoomOccupancies] SET [ID] = @ID, [TrainingParticipant_ID] = @TrainingParticipant_ID, [LodgingRoom_ID] = @LodgingRoom_ID, [StartDate] = @StartDate, [EndDate] = @EndDate, [CreateDate] = @CreateDate, [UpdateDate] = @UpdateDate, [UpdateUser] = @UpdateUser, [CreateUser] = @CreateUser WHERE (([ID] = @Original_ID) AND ([TrainingParticipant_ID] = @Original_TrainingParticipant_ID) AND ([LodgingRoom_ID] = @Original_LodgingRoom_ID) AND ([StartDate] = @Original_StartDate) AND ([EndDate] = @Original_EndDate) AND ([CreateDate] = @Original_CreateDate) AND ([UpdateDate] = @Original_UpdateDate) AND ([UpdateUser] = @Original_UpdateUser) AND ([CreateUser] = @Original_CreateUser));
SELECT ID, TrainingParticipant_ID, LodgingRoom_ID, StartDate, EndDate, CreateDate, UpdateDate, UpdateUser, CreateUser FROM TrainingRoomOccupancies WHERE (LodgingRoom_ID = @LodgingRoom_ID) AND (TrainingParticipant_ID = @TrainingParticipant_ID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@TrainingParticipant_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="TrainingParticipant_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@LodgingRoom_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="LodgingRoom_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@StartDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="StartDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@EndDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="EndDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@CreateDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="CreateDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@UpdateDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="UpdateDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@UpdateUser" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="UpdateUser" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@CreateUser" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="CreateUser" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_TrainingParticipant_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="TrainingParticipant_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_LodgingRoom_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="LodgingRoom_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_StartDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="StartDate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_EndDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="EndDate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_CreateDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="CreateDate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_UpdateDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="UpdateDate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_UpdateUser" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="UpdateUser" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_CreateUser" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="CreateUser" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ID" DataSetColumn="ID" />
              <Mapping SourceColumn="TrainingParticipant_ID" DataSetColumn="TrainingParticipant_ID" />
              <Mapping SourceColumn="LodgingRoom_ID" DataSetColumn="LodgingRoom_ID" />
              <Mapping SourceColumn="CreateDate" DataSetColumn="CreateDate" />
              <Mapping SourceColumn="UpdateDate" DataSetColumn="UpdateDate" />
              <Mapping SourceColumn="UpdateUser" DataSetColumn="UpdateUser" />
              <Mapping SourceColumn="CreateUser" DataSetColumn="CreateUser" />
              <Mapping SourceColumn="StartDate" DataSetColumn="StartDate" />
              <Mapping SourceColumn="EndDate" DataSetColumn="EndDate" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="GridAssocTableAdapter" GeneratorDataComponentClassName="GridAssocTableAdapter" Name="GridAssoc" UserDataComponentName="GridAssocTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ACHConnectionString (Settings)" DbObjectName="ACH.dbo.Expenses" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        CASE WHEN (NOT TPE.Expense_ID IS NULL) THEN (1) ELSE (0) END AS Assoc, E.ID, E.Type, E.Value
FROM            Expenses AS E LEFT OUTER JOIN
                         TrainingParticipants_Expenses AS TPE ON E.ID = TPE.Expense_ID AND TPE.TrainingParticipant_ID = @Participant_ID
ORDER BY E.Type</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="Participant_ID" ColumnName="TrainingParticipant_ID" DataSourceName="ACH.dbo.TrainingParticipants_Expenses" DataTypeServer="varchar(40)" DbType="AnsiString" Direction="Input" ParameterName="@Participant_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="40" SourceColumn="TrainingParticipant_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Assoc" DataSetColumn="Assoc" />
              <Mapping SourceColumn="ID" DataSetColumn="ID" />
              <Mapping SourceColumn="Type" DataSetColumn="Type" />
              <Mapping SourceColumn="Value" DataSetColumn="Value" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="RoomOccupanciesRadiosTableAdapter" GeneratorDataComponentClassName="RoomOccupanciesRadiosTableAdapter" Name="RoomOccupanciesRadios" UserDataComponentName="RoomOccupanciesRadiosTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ACHConnectionString (Settings)" DbObjectType="Unknown" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT        rt.NoOfBeds - COUNT(tro.LodgingRoom_ID) AS available, rt.NoOfBeds AS total, lr.ID, lr.Name AS Room
FROM            (SELECT        _tp.ID, _tp.Member_ID
                          FROM            TrainingParticipants AS _tp INNER JOIN
                                                    Trainings AS t ON _tp.Training_ID = t.ID
                          WHERE        (t.ID = @Training_ID)) AS tp INNER JOIN
                         Members AS m ON tp.Member_ID = m.ID INNER JOIN
                         TrainingRoomOccupancies AS tro ON tro.TrainingParticipant_ID = tp.ID RIGHT OUTER JOIN
                         LodgingRooms AS lr ON tro.LodgingRoom_ID = lr.ID INNER JOIN
                         RoomTypes AS rt ON rt.ID = lr.RoomType_ID
GROUP BY lr.Name, lr.ID, rt.NoOfBeds
ORDER BY Room</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="Training_ID" ColumnName="" DataSourceName="" DataTypeServer="varchar(40)" DbType="AnsiString" Direction="Input" ParameterName="@Training_ID" Precision="0" Scale="0" Size="40" SourceColumn="" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="available" DataSetColumn="available" />
              <Mapping SourceColumn="total" DataSetColumn="total" />
              <Mapping SourceColumn="ID" DataSetColumn="ID" />
              <Mapping SourceColumn="Room" DataSetColumn="Room" />
            </Mappings>
            <Sources />
          </TableAdapter>
        </Tables>
        <Sources />
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="ACHDataSet" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:EnableTableAdapterManager="True" msprop:Generator_DataSetName="ACHDataSet" msprop:Generator_UserDSName="ACHDataSet">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="Addresses" msprop:Generator_TableClassName="AddressesDataTable" msprop:Generator_TableVarName="tableAddresses" msprop:Generator_RowChangedName="AddressesRowChanged" msprop:Generator_TablePropName="Addresses" msprop:Generator_RowDeletingName="AddressesRowDeleting" msprop:Generator_RowChangingName="AddressesRowChanging" msprop:Generator_RowEvHandlerName="AddressesRowChangeEventHandler" msprop:Generator_RowDeletedName="AddressesRowDeleted" msprop:Generator_RowClassName="AddressesRow" msprop:Generator_UserTableName="Addresses" msprop:Generator_RowEvArgName="AddressesRowChangeEvent">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ID" msprop:Generator_ColumnVarNameInTable="columnID" msprop:Generator_ColumnPropNameInRow="ID" msprop:Generator_ColumnPropNameInTable="IDColumn" msprop:Generator_UserColumnName="ID">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="40" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Description" msprop:Generator_ColumnVarNameInTable="columnDescription" msprop:Generator_ColumnPropNameInRow="Description" msprop:Generator_ColumnPropNameInTable="DescriptionColumn" msprop:Generator_UserColumnName="Description" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="60" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Street" msprop:Generator_ColumnVarNameInTable="columnStreet" msprop:Generator_ColumnPropNameInRow="Street" msprop:Generator_ColumnPropNameInTable="StreetColumn" msprop:Generator_UserColumnName="Street" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="30" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Street2" msprop:Generator_ColumnVarNameInTable="columnStreet2" msprop:Generator_ColumnPropNameInRow="Street2" msprop:Generator_ColumnPropNameInTable="Street2Column" msprop:Generator_UserColumnName="Street2" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="30" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Zip" msprop:Generator_ColumnVarNameInTable="columnZip" msprop:Generator_ColumnPropNameInRow="Zip" msprop:Generator_ColumnPropNameInTable="ZipColumn" msprop:Generator_UserColumnName="Zip" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Location" msprop:Generator_ColumnVarNameInTable="columnLocation" msprop:Generator_ColumnPropNameInRow="Location" msprop:Generator_ColumnPropNameInTable="LocationColumn" msprop:Generator_UserColumnName="Location">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="30" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Country" msprop:Generator_ColumnVarNameInTable="columnCountry" msprop:Generator_ColumnPropNameInRow="Country" msprop:Generator_ColumnPropNameInTable="CountryColumn" msprop:Generator_UserColumnName="Country">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="5" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Phone1" msprop:Generator_ColumnVarNameInTable="columnPhone1" msprop:Generator_ColumnPropNameInRow="Phone1" msprop:Generator_ColumnPropNameInTable="Phone1Column" msprop:Generator_UserColumnName="Phone1" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Phone2" msprop:Generator_ColumnVarNameInTable="columnPhone2" msprop:Generator_ColumnPropNameInRow="Phone2" msprop:Generator_ColumnPropNameInTable="Phone2Column" msprop:Generator_UserColumnName="Phone2" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="EMail" msprop:Generator_ColumnVarNameInTable="columnEMail" msprop:Generator_ColumnPropNameInRow="EMail" msprop:Generator_ColumnPropNameInTable="EMailColumn" msprop:Generator_UserColumnName="EMail" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="60" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Website" msprop:Generator_ColumnVarNameInTable="columnWebsite" msprop:Generator_ColumnPropNameInRow="Website" msprop:Generator_ColumnPropNameInTable="WebsiteColumn" msprop:Generator_UserColumnName="Website" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="80" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="AdditionalInformation" msprop:Generator_ColumnVarNameInTable="columnAdditionalInformation" msprop:Generator_ColumnPropNameInRow="AdditionalInformation" msprop:Generator_ColumnPropNameInTable="AdditionalInformationColumn" msprop:Generator_UserColumnName="AdditionalInformation" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="CreateDate" msprop:Generator_ColumnVarNameInTable="columnCreateDate" msprop:Generator_ColumnPropNameInRow="CreateDate" msprop:Generator_ColumnPropNameInTable="CreateDateColumn" msprop:Generator_UserColumnName="CreateDate" type="xs:dateTime" />
              <xs:element name="UpdateDate" msprop:Generator_ColumnVarNameInTable="columnUpdateDate" msprop:Generator_ColumnPropNameInRow="UpdateDate" msprop:Generator_ColumnPropNameInTable="UpdateDateColumn" msprop:Generator_UserColumnName="UpdateDate" type="xs:dateTime" />
              <xs:element name="UpdateUser" msprop:Generator_ColumnVarNameInTable="columnUpdateUser" msprop:Generator_ColumnPropNameInRow="UpdateUser" msprop:Generator_ColumnPropNameInTable="UpdateUserColumn" msprop:Generator_UserColumnName="UpdateUser">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="4" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="CreateUser" msprop:Generator_ColumnVarNameInTable="columnCreateUser" msprop:Generator_ColumnPropNameInRow="CreateUser" msprop:Generator_ColumnPropNameInTable="CreateUserColumn" msprop:Generator_UserColumnName="CreateUser">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="4" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Locations" msprop:Generator_TableClassName="LocationsDataTable" msprop:Generator_TableVarName="tableLocations" msprop:Generator_RowChangedName="LocationsRowChanged" msprop:Generator_TablePropName="Locations" msprop:Generator_RowDeletingName="LocationsRowDeleting" msprop:Generator_RowChangingName="LocationsRowChanging" msprop:Generator_RowEvHandlerName="LocationsRowChangeEventHandler" msprop:Generator_RowDeletedName="LocationsRowDeleted" msprop:Generator_RowClassName="LocationsRow" msprop:Generator_UserTableName="Locations" msprop:Generator_RowEvArgName="LocationsRowChangeEvent">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ID" msprop:Generator_ColumnVarNameInTable="columnID" msprop:Generator_ColumnPropNameInRow="ID" msprop:Generator_ColumnPropNameInTable="IDColumn" msprop:Generator_UserColumnName="ID">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="40" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Description" msprop:Generator_ColumnVarNameInTable="columnDescription" msprop:Generator_ColumnPropNameInRow="Description" msprop:Generator_ColumnPropNameInTable="DescriptionColumn" msprop:Generator_UserColumnName="Description" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="60" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Name" msprop:Generator_ColumnVarNameInTable="columnName" msprop:Generator_ColumnPropNameInRow="Name" msprop:Generator_ColumnPropNameInTable="NameColumn" msprop:Generator_UserColumnName="Name">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="30" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Lodging_ID" msprop:Generator_ColumnVarNameInTable="columnLodging_ID" msprop:Generator_ColumnPropNameInRow="Lodging_ID" msprop:Generator_ColumnPropNameInTable="Lodging_IDColumn" msprop:Generator_UserColumnName="Lodging_ID">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="40" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="AdditionalInformation" msprop:Generator_ColumnVarNameInTable="columnAdditionalInformation" msprop:Generator_ColumnPropNameInRow="AdditionalInformation" msprop:Generator_ColumnPropNameInTable="AdditionalInformationColumn" msprop:Generator_UserColumnName="AdditionalInformation" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="CreateDate" msprop:Generator_ColumnVarNameInTable="columnCreateDate" msprop:Generator_ColumnPropNameInRow="CreateDate" msprop:Generator_ColumnPropNameInTable="CreateDateColumn" msprop:Generator_UserColumnName="CreateDate" type="xs:dateTime" />
              <xs:element name="UpdateDate" msprop:Generator_ColumnVarNameInTable="columnUpdateDate" msprop:Generator_ColumnPropNameInRow="UpdateDate" msprop:Generator_ColumnPropNameInTable="UpdateDateColumn" msprop:Generator_UserColumnName="UpdateDate" type="xs:dateTime" />
              <xs:element name="UpdateUser" msprop:Generator_ColumnVarNameInTable="columnUpdateUser" msprop:Generator_ColumnPropNameInRow="UpdateUser" msprop:Generator_ColumnPropNameInTable="UpdateUserColumn" msprop:Generator_UserColumnName="UpdateUser">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="4" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="CreateUser" msprop:Generator_ColumnVarNameInTable="columnCreateUser" msprop:Generator_ColumnPropNameInRow="CreateUser" msprop:Generator_ColumnPropNameInTable="CreateUserColumn" msprop:Generator_UserColumnName="CreateUser">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="4" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="LodgingRooms" msprop:Generator_TableClassName="LodgingRoomsDataTable" msprop:Generator_TableVarName="tableLodgingRooms" msprop:Generator_RowChangedName="LodgingRoomsRowChanged" msprop:Generator_TablePropName="LodgingRooms" msprop:Generator_RowDeletingName="LodgingRoomsRowDeleting" msprop:Generator_RowChangingName="LodgingRoomsRowChanging" msprop:Generator_RowEvHandlerName="LodgingRoomsRowChangeEventHandler" msprop:Generator_RowDeletedName="LodgingRoomsRowDeleted" msprop:Generator_RowClassName="LodgingRoomsRow" msprop:Generator_UserTableName="LodgingRooms" msprop:Generator_RowEvArgName="LodgingRoomsRowChangeEvent">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ID" msprop:Generator_ColumnVarNameInTable="columnID" msprop:Generator_ColumnPropNameInRow="ID" msprop:Generator_ColumnPropNameInTable="IDColumn" msprop:Generator_UserColumnName="ID">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="40" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Description" msprop:Generator_ColumnVarNameInTable="columnDescription" msprop:Generator_ColumnPropNameInRow="Description" msprop:Generator_ColumnPropNameInTable="DescriptionColumn" msprop:Generator_UserColumnName="Description" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="60" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Name" msprop:Generator_ColumnVarNameInTable="columnName" msprop:Generator_ColumnPropNameInRow="Name" msprop:Generator_ColumnPropNameInTable="NameColumn" msprop:Generator_UserColumnName="Name">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="30" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Lodging_ID" msprop:Generator_ColumnVarNameInTable="columnLodging_ID" msprop:Generator_ColumnPropNameInRow="Lodging_ID" msprop:Generator_ColumnPropNameInTable="Lodging_IDColumn" msprop:Generator_UserColumnName="Lodging_ID">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="40" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="RoomType_ID" msprop:Generator_ColumnVarNameInTable="columnRoomType_ID" msprop:Generator_ColumnPropNameInRow="RoomType_ID" msprop:Generator_ColumnPropNameInTable="RoomType_IDColumn" msprop:Generator_UserColumnName="RoomType_ID">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="40" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="CreateDate" msprop:Generator_ColumnVarNameInTable="columnCreateDate" msprop:Generator_ColumnPropNameInRow="CreateDate" msprop:Generator_ColumnPropNameInTable="CreateDateColumn" msprop:Generator_UserColumnName="CreateDate" type="xs:dateTime" />
              <xs:element name="UpdateDate" msprop:Generator_ColumnVarNameInTable="columnUpdateDate" msprop:Generator_ColumnPropNameInRow="UpdateDate" msprop:Generator_ColumnPropNameInTable="UpdateDateColumn" msprop:Generator_UserColumnName="UpdateDate" type="xs:dateTime" />
              <xs:element name="UpdateUser" msprop:Generator_ColumnVarNameInTable="columnUpdateUser" msprop:Generator_ColumnPropNameInRow="UpdateUser" msprop:Generator_ColumnPropNameInTable="UpdateUserColumn" msprop:Generator_UserColumnName="UpdateUser">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="4" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="CreateUser" msprop:Generator_ColumnVarNameInTable="columnCreateUser" msprop:Generator_ColumnPropNameInRow="CreateUser" msprop:Generator_ColumnPropNameInTable="CreateUserColumn" msprop:Generator_UserColumnName="CreateUser">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="4" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Lodgings" msprop:Generator_TableClassName="LodgingsDataTable" msprop:Generator_TableVarName="tableLodgings" msprop:Generator_RowChangedName="LodgingsRowChanged" msprop:Generator_TablePropName="Lodgings" msprop:Generator_RowDeletingName="LodgingsRowDeleting" msprop:Generator_RowChangingName="LodgingsRowChanging" msprop:Generator_RowEvHandlerName="LodgingsRowChangeEventHandler" msprop:Generator_RowDeletedName="LodgingsRowDeleted" msprop:Generator_RowClassName="LodgingsRow" msprop:Generator_UserTableName="Lodgings" msprop:Generator_RowEvArgName="LodgingsRowChangeEvent">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ID" msprop:Generator_ColumnVarNameInTable="columnID" msprop:Generator_ColumnPropNameInRow="ID" msprop:Generator_ColumnPropNameInTable="IDColumn" msprop:Generator_UserColumnName="ID">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="40" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Name" msprop:Generator_ColumnVarNameInTable="columnName" msprop:Generator_ColumnPropNameInRow="Name" msprop:Generator_ColumnPropNameInTable="NameColumn" msprop:Generator_UserColumnName="Name">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="30" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Address_ID" msprop:Generator_ColumnVarNameInTable="columnAddress_ID" msprop:Generator_ColumnPropNameInRow="Address_ID" msprop:Generator_ColumnPropNameInTable="Address_IDColumn" msprop:Generator_UserColumnName="Address_ID">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="40" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="AdditionalInformation" msprop:Generator_ColumnVarNameInTable="columnAdditionalInformation" msprop:Generator_ColumnPropNameInRow="AdditionalInformation" msprop:Generator_ColumnPropNameInTable="AdditionalInformationColumn" msprop:Generator_UserColumnName="AdditionalInformation" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="CreateDate" msprop:Generator_ColumnVarNameInTable="columnCreateDate" msprop:Generator_ColumnPropNameInRow="CreateDate" msprop:Generator_ColumnPropNameInTable="CreateDateColumn" msprop:Generator_UserColumnName="CreateDate" type="xs:dateTime" />
              <xs:element name="UpdateDate" msprop:Generator_ColumnVarNameInTable="columnUpdateDate" msprop:Generator_ColumnPropNameInRow="UpdateDate" msprop:Generator_ColumnPropNameInTable="UpdateDateColumn" msprop:Generator_UserColumnName="UpdateDate" type="xs:dateTime" />
              <xs:element name="UpdateUser" msprop:Generator_ColumnVarNameInTable="columnUpdateUser" msprop:Generator_ColumnPropNameInRow="UpdateUser" msprop:Generator_ColumnPropNameInTable="UpdateUserColumn" msprop:Generator_UserColumnName="UpdateUser">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="4" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="CreateUser" msprop:Generator_ColumnVarNameInTable="columnCreateUser" msprop:Generator_ColumnPropNameInRow="CreateUser" msprop:Generator_ColumnPropNameInTable="CreateUserColumn" msprop:Generator_UserColumnName="CreateUser">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="4" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Members" msprop:Generator_TableClassName="MembersDataTable" msprop:Generator_TableVarName="tableMembers" msprop:Generator_RowChangedName="MembersRowChanged" msprop:Generator_TablePropName="Members" msprop:Generator_RowDeletingName="MembersRowDeleting" msprop:Generator_RowChangingName="MembersRowChanging" msprop:Generator_RowEvHandlerName="MembersRowChangeEventHandler" msprop:Generator_RowDeletedName="MembersRowDeleted" msprop:Generator_RowClassName="MembersRow" msprop:Generator_UserTableName="Members" msprop:Generator_RowEvArgName="MembersRowChangeEvent">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ID" msprop:Generator_ColumnVarNameInTable="columnID" msprop:Generator_ColumnPropNameInRow="ID" msprop:Generator_ColumnPropNameInTable="IDColumn" msprop:Generator_UserColumnName="ID">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="40" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Name" msprop:Generator_ColumnVarNameInTable="columnName" msprop:Generator_ColumnPropNameInRow="Name" msprop:Generator_ColumnPropNameInTable="NameColumn" msprop:Generator_UserColumnName="Name">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Code" msprop:Generator_ColumnVarNameInTable="columnCode" msprop:Generator_ColumnPropNameInRow="Code" msprop:Generator_ColumnPropNameInTable="CodeColumn" msprop:Generator_UserColumnName="Code">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="4" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Usable" msprop:Generator_ColumnVarNameInTable="columnUsable" msprop:Generator_ColumnPropNameInRow="Usable" msprop:Generator_ColumnPropNameInTable="UsableColumn" msprop:Generator_UserColumnName="Usable" type="xs:boolean" />
              <xs:element name="Address_ID" msprop:Generator_ColumnVarNameInTable="columnAddress_ID" msprop:Generator_ColumnPropNameInRow="Address_ID" msprop:Generator_ColumnPropNameInTable="Address_IDColumn" msprop:Generator_UserColumnName="Address_ID" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="40" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="EMail" msprop:Generator_ColumnVarNameInTable="columnEMail" msprop:Generator_ColumnPropNameInRow="EMail" msprop:Generator_ColumnPropNameInTable="EMailColumn" msprop:Generator_UserColumnName="EMail" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="PositionType_ID" msprop:Generator_ColumnVarNameInTable="columnPositionType_ID" msprop:Generator_ColumnPropNameInRow="PositionType_ID" msprop:Generator_ColumnPropNameInTable="PositionType_IDColumn" msprop:Generator_UserColumnName="PositionType_ID">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="40" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="MobilePhone" msprop:Generator_ColumnVarNameInTable="columnMobilePhone" msprop:Generator_ColumnPropNameInRow="MobilePhone" msprop:Generator_ColumnPropNameInTable="MobilePhoneColumn" msprop:Generator_UserColumnName="MobilePhone" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Phone" msprop:Generator_ColumnVarNameInTable="columnPhone" msprop:Generator_ColumnPropNameInRow="Phone" msprop:Generator_ColumnPropNameInTable="PhoneColumn" msprop:Generator_UserColumnName="Phone" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Fax" msprop:Generator_ColumnVarNameInTable="columnFax" msprop:Generator_ColumnPropNameInRow="Fax" msprop:Generator_ColumnPropNameInTable="FaxColumn" msprop:Generator_UserColumnName="Fax" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="CreateDate" msprop:Generator_ColumnVarNameInTable="columnCreateDate" msprop:Generator_ColumnPropNameInRow="CreateDate" msprop:Generator_ColumnPropNameInTable="CreateDateColumn" msprop:Generator_UserColumnName="CreateDate" type="xs:dateTime" />
              <xs:element name="UpdateDate" msprop:Generator_ColumnVarNameInTable="columnUpdateDate" msprop:Generator_ColumnPropNameInRow="UpdateDate" msprop:Generator_ColumnPropNameInTable="UpdateDateColumn" msprop:Generator_UserColumnName="UpdateDate" type="xs:dateTime" />
              <xs:element name="UpdateUser" msprop:Generator_ColumnVarNameInTable="columnUpdateUser" msprop:Generator_ColumnPropNameInRow="UpdateUser" msprop:Generator_ColumnPropNameInTable="UpdateUserColumn" msprop:Generator_UserColumnName="UpdateUser">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="4" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="CreateUser" msprop:Generator_ColumnVarNameInTable="columnCreateUser" msprop:Generator_ColumnPropNameInRow="CreateUser" msprop:Generator_ColumnPropNameInTable="CreateUserColumn" msprop:Generator_UserColumnName="CreateUser">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="4" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="PositionTypes" msprop:Generator_TableClassName="PositionTypesDataTable" msprop:Generator_TableVarName="tablePositionTypes" msprop:Generator_RowChangedName="PositionTypesRowChanged" msprop:Generator_TablePropName="PositionTypes" msprop:Generator_RowDeletingName="PositionTypesRowDeleting" msprop:Generator_RowChangingName="PositionTypesRowChanging" msprop:Generator_RowEvHandlerName="PositionTypesRowChangeEventHandler" msprop:Generator_RowDeletedName="PositionTypesRowDeleted" msprop:Generator_RowClassName="PositionTypesRow" msprop:Generator_UserTableName="PositionTypes" msprop:Generator_RowEvArgName="PositionTypesRowChangeEvent">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ID" msprop:Generator_ColumnVarNameInTable="columnID" msprop:Generator_ColumnPropNameInRow="ID" msprop:Generator_ColumnPropNameInTable="IDColumn" msprop:Generator_UserColumnName="ID">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="40" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Name" msprop:Generator_ColumnVarNameInTable="columnName" msprop:Generator_ColumnPropNameInRow="Name" msprop:Generator_ColumnPropNameInTable="NameColumn" msprop:Generator_UserColumnName="Name">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Duties" msprop:Generator_ColumnVarNameInTable="columnDuties" msprop:Generator_ColumnPropNameInRow="Duties" msprop:Generator_ColumnPropNameInTable="DutiesColumn" msprop:Generator_UserColumnName="Duties" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="CreateDate" msprop:Generator_ColumnVarNameInTable="columnCreateDate" msprop:Generator_ColumnPropNameInRow="CreateDate" msprop:Generator_ColumnPropNameInTable="CreateDateColumn" msprop:Generator_UserColumnName="CreateDate" type="xs:dateTime" />
              <xs:element name="UpdateDate" msprop:Generator_ColumnVarNameInTable="columnUpdateDate" msprop:Generator_ColumnPropNameInRow="UpdateDate" msprop:Generator_ColumnPropNameInTable="UpdateDateColumn" msprop:Generator_UserColumnName="UpdateDate" type="xs:dateTime" />
              <xs:element name="UpdateUser" msprop:Generator_ColumnVarNameInTable="columnUpdateUser" msprop:Generator_ColumnPropNameInRow="UpdateUser" msprop:Generator_ColumnPropNameInTable="UpdateUserColumn" msprop:Generator_UserColumnName="UpdateUser">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="4" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="CreateUser" msprop:Generator_ColumnVarNameInTable="columnCreateUser" msprop:Generator_ColumnPropNameInRow="CreateUser" msprop:Generator_ColumnPropNameInTable="CreateUserColumn" msprop:Generator_UserColumnName="CreateUser">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="4" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="RoomTypes" msprop:Generator_TableClassName="RoomTypesDataTable" msprop:Generator_TableVarName="tableRoomTypes" msprop:Generator_RowChangedName="RoomTypesRowChanged" msprop:Generator_TablePropName="RoomTypes" msprop:Generator_RowDeletingName="RoomTypesRowDeleting" msprop:Generator_RowChangingName="RoomTypesRowChanging" msprop:Generator_RowEvHandlerName="RoomTypesRowChangeEventHandler" msprop:Generator_RowDeletedName="RoomTypesRowDeleted" msprop:Generator_RowClassName="RoomTypesRow" msprop:Generator_UserTableName="RoomTypes" msprop:Generator_RowEvArgName="RoomTypesRowChangeEvent">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ID" msprop:Generator_ColumnVarNameInTable="columnID" msprop:Generator_ColumnPropNameInRow="ID" msprop:Generator_ColumnPropNameInTable="IDColumn" msprop:Generator_UserColumnName="ID">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="40" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="NoOfBeds" msprop:Generator_ColumnVarNameInTable="columnNoOfBeds" msprop:Generator_ColumnPropNameInRow="NoOfBeds" msprop:Generator_ColumnPropNameInTable="NoOfBedsColumn" msprop:Generator_UserColumnName="NoOfBeds" type="xs:int" />
              <xs:element name="PricePerBedKid" msprop:Generator_ColumnVarNameInTable="columnPricePerBedKid" msprop:Generator_ColumnPropNameInRow="PricePerBedKid" msprop:Generator_ColumnPropNameInTable="PricePerBedKidColumn" msprop:Generator_UserColumnName="PricePerBedKid" type="xs:int" />
              <xs:element name="PricePerBedAdult" msprop:Generator_ColumnVarNameInTable="columnPricePerBedAdult" msprop:Generator_ColumnPropNameInRow="PricePerBedAdult" msprop:Generator_ColumnPropNameInTable="PricePerBedAdultColumn" msprop:Generator_UserColumnName="PricePerBedAdult" type="xs:int" />
              <xs:element name="PricePerBedGuestKid" msprop:Generator_ColumnVarNameInTable="columnPricePerBedGuestKid" msprop:Generator_ColumnPropNameInRow="PricePerBedGuestKid" msprop:Generator_ColumnPropNameInTable="PricePerBedGuestKidColumn" msprop:Generator_UserColumnName="PricePerBedGuestKid" type="xs:int" />
              <xs:element name="PricePerBedGuestAdult" msprop:Generator_ColumnVarNameInTable="columnPricePerBedGuestAdult" msprop:Generator_ColumnPropNameInRow="PricePerBedGuestAdult" msprop:Generator_ColumnPropNameInTable="PricePerBedGuestAdultColumn" msprop:Generator_UserColumnName="PricePerBedGuestAdult" type="xs:int" />
              <xs:element name="CreateDate" msprop:Generator_ColumnVarNameInTable="columnCreateDate" msprop:Generator_ColumnPropNameInRow="CreateDate" msprop:Generator_ColumnPropNameInTable="CreateDateColumn" msprop:Generator_UserColumnName="CreateDate" type="xs:dateTime" />
              <xs:element name="UpdateDate" msprop:Generator_ColumnVarNameInTable="columnUpdateDate" msprop:Generator_ColumnPropNameInRow="UpdateDate" msprop:Generator_ColumnPropNameInTable="UpdateDateColumn" msprop:Generator_UserColumnName="UpdateDate" type="xs:dateTime" />
              <xs:element name="UpdateUser" msprop:Generator_ColumnVarNameInTable="columnUpdateUser" msprop:Generator_ColumnPropNameInRow="UpdateUser" msprop:Generator_ColumnPropNameInTable="UpdateUserColumn" msprop:Generator_UserColumnName="UpdateUser">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="4" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="CreateUser" msprop:Generator_ColumnVarNameInTable="columnCreateUser" msprop:Generator_ColumnPropNameInRow="CreateUser" msprop:Generator_ColumnPropNameInTable="CreateUserColumn" msprop:Generator_UserColumnName="CreateUser">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="4" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="PricePerBedTrainer" msprop:Generator_ColumnVarNameInTable="columnPricePerBedTrainer" msprop:Generator_ColumnPropNameInRow="PricePerBedTrainer" msprop:Generator_ColumnPropNameInTable="PricePerBedTrainerColumn" msprop:Generator_UserColumnName="PricePerBedTrainer" type="xs:int" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="TrainingParticipantPositions" msprop:Generator_TableClassName="TrainingParticipantPositionsDataTable" msprop:Generator_TableVarName="tableTrainingParticipantPositions" msprop:Generator_RowChangedName="TrainingParticipantPositionsRowChanged" msprop:Generator_TablePropName="TrainingParticipantPositions" msprop:Generator_RowDeletingName="TrainingParticipantPositionsRowDeleting" msprop:Generator_RowChangingName="TrainingParticipantPositionsRowChanging" msprop:Generator_RowEvHandlerName="TrainingParticipantPositionsRowChangeEventHandler" msprop:Generator_RowDeletedName="TrainingParticipantPositionsRowDeleted" msprop:Generator_RowClassName="TrainingParticipantPositionsRow" msprop:Generator_UserTableName="TrainingParticipantPositions" msprop:Generator_RowEvArgName="TrainingParticipantPositionsRowChangeEvent">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ID" msprop:Generator_ColumnVarNameInTable="columnID" msprop:Generator_ColumnPropNameInRow="ID" msprop:Generator_ColumnPropNameInTable="IDColumn" msprop:Generator_UserColumnName="ID">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="40" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Name" msprop:Generator_ColumnVarNameInTable="columnName" msprop:Generator_ColumnPropNameInRow="Name" msprop:Generator_ColumnPropNameInTable="NameColumn" msprop:Generator_UserColumnName="Name">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Duties" msprop:Generator_ColumnVarNameInTable="columnDuties" msprop:Generator_ColumnPropNameInRow="Duties" msprop:Generator_ColumnPropNameInTable="DutiesColumn" msprop:Generator_UserColumnName="Duties" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="CreateDate" msprop:Generator_ColumnVarNameInTable="columnCreateDate" msprop:Generator_ColumnPropNameInRow="CreateDate" msprop:Generator_ColumnPropNameInTable="CreateDateColumn" msprop:Generator_UserColumnName="CreateDate" type="xs:dateTime" />
              <xs:element name="UpdateDate" msprop:Generator_ColumnVarNameInTable="columnUpdateDate" msprop:Generator_ColumnPropNameInRow="UpdateDate" msprop:Generator_ColumnPropNameInTable="UpdateDateColumn" msprop:Generator_UserColumnName="UpdateDate" type="xs:dateTime" />
              <xs:element name="UpdateUser" msprop:Generator_ColumnVarNameInTable="columnUpdateUser" msprop:Generator_ColumnPropNameInRow="UpdateUser" msprop:Generator_ColumnPropNameInTable="UpdateUserColumn" msprop:Generator_UserColumnName="UpdateUser">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="4" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="CreateUser" msprop:Generator_ColumnVarNameInTable="columnCreateUser" msprop:Generator_ColumnPropNameInRow="CreateUser" msprop:Generator_ColumnPropNameInTable="CreateUserColumn" msprop:Generator_UserColumnName="CreateUser">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="4" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="TrainingParticipants" msprop:Generator_TableClassName="TrainingParticipantsDataTable" msprop:Generator_TableVarName="tableTrainingParticipants" msprop:Generator_RowChangedName="TrainingParticipantsRowChanged" msprop:Generator_TablePropName="TrainingParticipants" msprop:Generator_RowDeletingName="TrainingParticipantsRowDeleting" msprop:Generator_RowChangingName="TrainingParticipantsRowChanging" msprop:Generator_RowEvHandlerName="TrainingParticipantsRowChangeEventHandler" msprop:Generator_RowDeletedName="TrainingParticipantsRowDeleted" msprop:Generator_RowClassName="TrainingParticipantsRow" msprop:Generator_UserTableName="TrainingParticipants" msprop:Generator_RowEvArgName="TrainingParticipantsRowChangeEvent">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ID" msprop:Generator_ColumnVarNameInTable="columnID" msprop:Generator_ColumnPropNameInRow="ID" msprop:Generator_ColumnPropNameInTable="IDColumn" msprop:Generator_UserColumnName="ID">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="40" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Training_ID" msprop:Generator_ColumnVarNameInTable="columnTraining_ID" msprop:Generator_ColumnPropNameInRow="Training_ID" msprop:Generator_ColumnPropNameInTable="Training_IDColumn" msprop:Generator_UserColumnName="Training_ID">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="40" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Member_ID" msprop:Generator_ColumnVarNameInTable="columnMember_ID" msprop:Generator_ColumnPropNameInRow="Member_ID" msprop:Generator_ColumnPropNameInTable="Member_IDColumn" msprop:Generator_UserColumnName="Member_ID">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="40" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Position_ID" msprop:Generator_ColumnVarNameInTable="columnPosition_ID" msprop:Generator_ColumnPropNameInRow="Position_ID" msprop:Generator_ColumnPropNameInTable="Position_IDColumn" msprop:Generator_UserColumnName="Position_ID">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="40" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="StartDate" msprop:Generator_ColumnVarNameInTable="columnStartDate" msprop:Generator_ColumnPropNameInRow="StartDate" msprop:Generator_ColumnPropNameInTable="StartDateColumn" msprop:Generator_UserColumnName="StartDate" type="xs:dateTime" minOccurs="0" />
              <xs:element name="EndDate" msprop:Generator_ColumnVarNameInTable="columnEndDate" msprop:Generator_ColumnPropNameInRow="EndDate" msprop:Generator_ColumnPropNameInTable="EndDateColumn" msprop:Generator_UserColumnName="EndDate" type="xs:dateTime" minOccurs="0" />
              <xs:element name="CreateDate" msprop:Generator_ColumnVarNameInTable="columnCreateDate" msprop:Generator_ColumnPropNameInRow="CreateDate" msprop:Generator_ColumnPropNameInTable="CreateDateColumn" msprop:Generator_UserColumnName="CreateDate" type="xs:dateTime" />
              <xs:element name="UpdateDate" msprop:Generator_ColumnVarNameInTable="columnUpdateDate" msprop:Generator_ColumnPropNameInRow="UpdateDate" msprop:Generator_ColumnPropNameInTable="UpdateDateColumn" msprop:Generator_UserColumnName="UpdateDate" type="xs:dateTime" />
              <xs:element name="UpdateUser" msprop:Generator_ColumnVarNameInTable="columnUpdateUser" msprop:Generator_ColumnPropNameInRow="UpdateUser" msprop:Generator_ColumnPropNameInTable="UpdateUserColumn" msprop:Generator_UserColumnName="UpdateUser">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="4" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="CreateUser" msprop:Generator_ColumnVarNameInTable="columnCreateUser" msprop:Generator_ColumnPropNameInRow="CreateUser" msprop:Generator_ColumnPropNameInTable="CreateUserColumn" msprop:Generator_UserColumnName="CreateUser">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="4" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Room_ID" msprop:Generator_ColumnVarNameInTable="columnRoom_ID" msprop:Generator_ColumnPropNameInRow="Room_ID" msprop:Generator_ColumnPropNameInTable="Room_IDColumn" msprop:Generator_UserColumnName="Room_ID" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="40" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="room_name" msprop:Generator_ColumnVarNameInTable="columnroom_name" msprop:Generator_ColumnPropNameInRow="room_name" msprop:Generator_ColumnPropNameInTable="room_nameColumn" msprop:Generator_UserColumnName="room_name" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="30" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Expr1" msprop:Generator_ColumnVarNameInTable="columnExpr1" msprop:Generator_ColumnPropNameInRow="Expr1" msprop:Generator_ColumnPropNameInTable="Expr1Column" msprop:Generator_UserColumnName="Expr1" type="xs:dateTime" />
              <xs:element name="Expr2" msprop:Generator_ColumnVarNameInTable="columnExpr2" msprop:Generator_ColumnPropNameInRow="Expr2" msprop:Generator_ColumnPropNameInTable="Expr2Column" msprop:Generator_UserColumnName="Expr2" type="xs:dateTime" />
              <xs:element name="Training_Name" msprop:Generator_ColumnVarNameInTable="columnTraining_Name" msprop:Generator_ColumnPropNameInRow="Training_Name" msprop:Generator_ColumnPropNameInTable="Training_NameColumn" msprop:Generator_UserColumnName="Training_Name">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Trainings" msprop:Generator_TableClassName="TrainingsDataTable" msprop:Generator_TableVarName="tableTrainings" msprop:Generator_RowChangedName="TrainingsRowChanged" msprop:Generator_TablePropName="Trainings" msprop:Generator_RowDeletingName="TrainingsRowDeleting" msprop:Generator_RowChangingName="TrainingsRowChanging" msprop:Generator_RowEvHandlerName="TrainingsRowChangeEventHandler" msprop:Generator_RowDeletedName="TrainingsRowDeleted" msprop:Generator_RowClassName="TrainingsRow" msprop:Generator_UserTableName="Trainings" msprop:Generator_RowEvArgName="TrainingsRowChangeEvent">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ID" msprop:Generator_ColumnVarNameInTable="columnID" msprop:Generator_ColumnPropNameInRow="ID" msprop:Generator_ColumnPropNameInTable="IDColumn" msprop:Generator_UserColumnName="ID">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="40" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Name" msprop:Generator_ColumnVarNameInTable="columnName" msprop:Generator_ColumnPropNameInRow="Name" msprop:Generator_ColumnPropNameInTable="NameColumn" msprop:Generator_UserColumnName="Name">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="StartDate" msprop:Generator_ColumnVarNameInTable="columnStartDate" msprop:Generator_ColumnPropNameInRow="StartDate" msprop:Generator_ColumnPropNameInTable="StartDateColumn" msprop:Generator_UserColumnName="StartDate" type="xs:dateTime" />
              <xs:element name="EndDate" msprop:Generator_ColumnVarNameInTable="columnEndDate" msprop:Generator_ColumnPropNameInRow="EndDate" msprop:Generator_ColumnPropNameInTable="EndDateColumn" msprop:Generator_UserColumnName="EndDate" type="xs:dateTime" />
              <xs:element name="Location_ID" msprop:Generator_ColumnVarNameInTable="columnLocation_ID" msprop:Generator_ColumnPropNameInRow="Location_ID" msprop:Generator_ColumnPropNameInTable="Location_IDColumn" msprop:Generator_UserColumnName="Location_ID">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="40" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="TrainingType_ID" msprop:Generator_ColumnVarNameInTable="columnTrainingType_ID" msprop:Generator_ColumnPropNameInRow="TrainingType_ID" msprop:Generator_ColumnPropNameInTable="TrainingType_IDColumn" msprop:Generator_UserColumnName="TrainingType_ID" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="40" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="CreateDate" msprop:Generator_ColumnVarNameInTable="columnCreateDate" msprop:Generator_ColumnPropNameInRow="CreateDate" msprop:Generator_ColumnPropNameInTable="CreateDateColumn" msprop:Generator_UserColumnName="CreateDate" type="xs:dateTime" />
              <xs:element name="UpdateDate" msprop:Generator_ColumnVarNameInTable="columnUpdateDate" msprop:Generator_ColumnPropNameInRow="UpdateDate" msprop:Generator_ColumnPropNameInTable="UpdateDateColumn" msprop:Generator_UserColumnName="UpdateDate" type="xs:dateTime" />
              <xs:element name="UpdateUser" msprop:Generator_ColumnVarNameInTable="columnUpdateUser" msprop:Generator_ColumnPropNameInRow="UpdateUser" msprop:Generator_ColumnPropNameInTable="UpdateUserColumn" msprop:Generator_UserColumnName="UpdateUser">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="4" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="CreateUser" msprop:Generator_ColumnVarNameInTable="columnCreateUser" msprop:Generator_ColumnPropNameInRow="CreateUser" msprop:Generator_ColumnPropNameInTable="CreateUserColumn" msprop:Generator_UserColumnName="CreateUser">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="4" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="TrainingTypes" msprop:Generator_TableClassName="TrainingTypesDataTable" msprop:Generator_TableVarName="tableTrainingTypes" msprop:Generator_RowChangedName="TrainingTypesRowChanged" msprop:Generator_TablePropName="TrainingTypes" msprop:Generator_RowDeletingName="TrainingTypesRowDeleting" msprop:Generator_RowChangingName="TrainingTypesRowChanging" msprop:Generator_RowEvHandlerName="TrainingTypesRowChangeEventHandler" msprop:Generator_RowDeletedName="TrainingTypesRowDeleted" msprop:Generator_RowClassName="TrainingTypesRow" msprop:Generator_UserTableName="TrainingTypes" msprop:Generator_RowEvArgName="TrainingTypesRowChangeEvent">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ID" msprop:Generator_ColumnVarNameInTable="columnID" msprop:Generator_ColumnPropNameInRow="ID" msprop:Generator_ColumnPropNameInTable="IDColumn" msprop:Generator_UserColumnName="ID">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="40" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Name" msprop:Generator_ColumnVarNameInTable="columnName" msprop:Generator_ColumnPropNameInRow="Name" msprop:Generator_ColumnPropNameInTable="NameColumn" msprop:Generator_UserColumnName="Name">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Description" msprop:Generator_ColumnVarNameInTable="columnDescription" msprop:Generator_ColumnPropNameInRow="Description" msprop:Generator_ColumnPropNameInTable="DescriptionColumn" msprop:Generator_UserColumnName="Description" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="CreateDate" msprop:Generator_ColumnVarNameInTable="columnCreateDate" msprop:Generator_ColumnPropNameInRow="CreateDate" msprop:Generator_ColumnPropNameInTable="CreateDateColumn" msprop:Generator_UserColumnName="CreateDate" type="xs:dateTime" />
              <xs:element name="UpdateDate" msprop:Generator_ColumnVarNameInTable="columnUpdateDate" msprop:Generator_ColumnPropNameInRow="UpdateDate" msprop:Generator_ColumnPropNameInTable="UpdateDateColumn" msprop:Generator_UserColumnName="UpdateDate" type="xs:dateTime" />
              <xs:element name="UpdateUser" msprop:Generator_ColumnVarNameInTable="columnUpdateUser" msprop:Generator_ColumnPropNameInRow="UpdateUser" msprop:Generator_ColumnPropNameInTable="UpdateUserColumn" msprop:Generator_UserColumnName="UpdateUser">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="4" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="CreateUser" msprop:Generator_ColumnVarNameInTable="columnCreateUser" msprop:Generator_ColumnPropNameInRow="CreateUser" msprop:Generator_ColumnPropNameInTable="CreateUserColumn" msprop:Generator_UserColumnName="CreateUser">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="4" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Expenses" msprop:Generator_TableClassName="ExpensesDataTable" msprop:Generator_TableVarName="tableExpenses" msprop:Generator_RowChangedName="ExpensesRowChanged" msprop:Generator_TablePropName="Expenses" msprop:Generator_RowDeletingName="ExpensesRowDeleting" msprop:Generator_RowChangingName="ExpensesRowChanging" msprop:Generator_RowEvHandlerName="ExpensesRowChangeEventHandler" msprop:Generator_RowDeletedName="ExpensesRowDeleted" msprop:Generator_RowClassName="ExpensesRow" msprop:Generator_UserTableName="Expenses" msprop:Generator_RowEvArgName="ExpensesRowChangeEvent">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ID" msprop:Generator_ColumnVarNameInTable="columnID" msprop:Generator_ColumnPropNameInRow="ID" msprop:Generator_ColumnPropNameInTable="IDColumn" msprop:Generator_UserColumnName="ID">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="40" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Type" msprop:Generator_ColumnVarNameInTable="columnType" msprop:Generator_ColumnPropNameInRow="Type" msprop:Generator_ColumnPropNameInTable="TypeColumn" msprop:Generator_UserColumnName="Type">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Value" msprop:Generator_ColumnVarNameInTable="columnValue" msprop:Generator_ColumnPropNameInRow="Value" msprop:Generator_ColumnPropNameInTable="ValueColumn" msprop:Generator_UserColumnName="Value" type="xs:decimal" />
              <xs:element name="CreateDate" msprop:Generator_ColumnVarNameInTable="columnCreateDate" msprop:Generator_ColumnPropNameInRow="CreateDate" msprop:Generator_ColumnPropNameInTable="CreateDateColumn" msprop:Generator_UserColumnName="CreateDate" type="xs:dateTime" />
              <xs:element name="UpdateDate" msprop:Generator_ColumnVarNameInTable="columnUpdateDate" msprop:Generator_ColumnPropNameInRow="UpdateDate" msprop:Generator_ColumnPropNameInTable="UpdateDateColumn" msprop:Generator_UserColumnName="UpdateDate" type="xs:dateTime" />
              <xs:element name="UpdateUser" msprop:Generator_ColumnVarNameInTable="columnUpdateUser" msprop:Generator_ColumnPropNameInRow="UpdateUser" msprop:Generator_ColumnPropNameInTable="UpdateUserColumn" msprop:Generator_UserColumnName="UpdateUser">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="4" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="CreateUser" msprop:Generator_ColumnVarNameInTable="columnCreateUser" msprop:Generator_ColumnPropNameInRow="CreateUser" msprop:Generator_ColumnPropNameInTable="CreateUserColumn" msprop:Generator_UserColumnName="CreateUser">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="4" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="TrainingParticipants_Expenses" msprop:Generator_TableClassName="TrainingParticipants_ExpensesDataTable" msprop:Generator_TableVarName="tableTrainingParticipants_Expenses" msprop:Generator_RowChangedName="TrainingParticipants_ExpensesRowChanged" msprop:Generator_TablePropName="TrainingParticipants_Expenses" msprop:Generator_RowDeletingName="TrainingParticipants_ExpensesRowDeleting" msprop:Generator_RowChangingName="TrainingParticipants_ExpensesRowChanging" msprop:Generator_RowEvHandlerName="TrainingParticipants_ExpensesRowChangeEventHandler" msprop:Generator_RowDeletedName="TrainingParticipants_ExpensesRowDeleted" msprop:Generator_RowClassName="TrainingParticipants_ExpensesRow" msprop:Generator_UserTableName="TrainingParticipants_Expenses" msprop:Generator_RowEvArgName="TrainingParticipants_ExpensesRowChangeEvent">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ID" msprop:Generator_ColumnVarNameInTable="columnID" msprop:Generator_ColumnPropNameInRow="ID" msprop:Generator_ColumnPropNameInTable="IDColumn" msprop:Generator_UserColumnName="ID">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="40" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="TrainingParticipant_ID" msprop:Generator_ColumnVarNameInTable="columnTrainingParticipant_ID" msprop:Generator_ColumnPropNameInRow="TrainingParticipant_ID" msprop:Generator_ColumnPropNameInTable="TrainingParticipant_IDColumn" msprop:Generator_UserColumnName="TrainingParticipant_ID">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="40" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="CreateDate" msprop:Generator_ColumnVarNameInTable="columnCreateDate" msprop:Generator_ColumnPropNameInRow="CreateDate" msprop:Generator_ColumnPropNameInTable="CreateDateColumn" msprop:Generator_UserColumnName="CreateDate" type="xs:dateTime" />
              <xs:element name="UpdateDate" msprop:Generator_ColumnVarNameInTable="columnUpdateDate" msprop:Generator_ColumnPropNameInRow="UpdateDate" msprop:Generator_ColumnPropNameInTable="UpdateDateColumn" msprop:Generator_UserColumnName="UpdateDate" type="xs:dateTime" />
              <xs:element name="UpdateUser" msprop:Generator_ColumnVarNameInTable="columnUpdateUser" msprop:Generator_ColumnPropNameInRow="UpdateUser" msprop:Generator_ColumnPropNameInTable="UpdateUserColumn" msprop:Generator_UserColumnName="UpdateUser">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="4" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="CreateUser" msprop:Generator_ColumnVarNameInTable="columnCreateUser" msprop:Generator_ColumnPropNameInRow="CreateUser" msprop:Generator_ColumnPropNameInTable="CreateUserColumn" msprop:Generator_UserColumnName="CreateUser">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="4" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Expense_ID" msprop:Generator_ColumnVarNameInTable="columnExpense_ID" msprop:Generator_ColumnPropNameInRow="Expense_ID" msprop:Generator_ColumnPropNameInTable="Expense_IDColumn" msprop:Generator_UserColumnName="Expense_ID">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="40" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="TrainingRoomOccupancies" msprop:Generator_TableClassName="TrainingRoomOccupanciesDataTable" msprop:Generator_TableVarName="tableTrainingRoomOccupancies" msprop:Generator_TablePropName="TrainingRoomOccupancies" msprop:Generator_RowDeletingName="TrainingRoomOccupanciesRowDeleting" msprop:Generator_RowChangingName="TrainingRoomOccupanciesRowChanging" msprop:Generator_RowEvHandlerName="TrainingRoomOccupanciesRowChangeEventHandler" msprop:Generator_RowDeletedName="TrainingRoomOccupanciesRowDeleted" msprop:Generator_UserTableName="TrainingRoomOccupancies" msprop:Generator_RowChangedName="TrainingRoomOccupanciesRowChanged" msprop:Generator_RowEvArgName="TrainingRoomOccupanciesRowChangeEvent" msprop:Generator_RowClassName="TrainingRoomOccupanciesRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ID" msprop:Generator_ColumnVarNameInTable="columnID" msprop:Generator_ColumnPropNameInRow="ID" msprop:Generator_ColumnPropNameInTable="IDColumn" msprop:Generator_UserColumnName="ID">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="40" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="TrainingParticipant_ID" msprop:Generator_ColumnVarNameInTable="columnTrainingParticipant_ID" msprop:Generator_ColumnPropNameInRow="TrainingParticipant_ID" msprop:Generator_ColumnPropNameInTable="TrainingParticipant_IDColumn" msprop:Generator_UserColumnName="TrainingParticipant_ID">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="40" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="LodgingRoom_ID" msprop:Generator_ColumnVarNameInTable="columnLodgingRoom_ID" msprop:Generator_ColumnPropNameInRow="LodgingRoom_ID" msprop:Generator_ColumnPropNameInTable="LodgingRoom_IDColumn" msprop:Generator_UserColumnName="LodgingRoom_ID">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="40" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="CreateDate" msprop:Generator_ColumnVarNameInTable="columnCreateDate" msprop:Generator_ColumnPropNameInRow="CreateDate" msprop:Generator_ColumnPropNameInTable="CreateDateColumn" msprop:Generator_UserColumnName="CreateDate" type="xs:dateTime" />
              <xs:element name="UpdateDate" msprop:Generator_ColumnVarNameInTable="columnUpdateDate" msprop:Generator_ColumnPropNameInRow="UpdateDate" msprop:Generator_ColumnPropNameInTable="UpdateDateColumn" msprop:Generator_UserColumnName="UpdateDate" type="xs:dateTime" />
              <xs:element name="UpdateUser" msprop:Generator_ColumnVarNameInTable="columnUpdateUser" msprop:Generator_ColumnPropNameInRow="UpdateUser" msprop:Generator_ColumnPropNameInTable="UpdateUserColumn" msprop:Generator_UserColumnName="UpdateUser">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="4" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="CreateUser" msprop:Generator_ColumnVarNameInTable="columnCreateUser" msprop:Generator_ColumnPropNameInRow="CreateUser" msprop:Generator_ColumnPropNameInTable="CreateUserColumn" msprop:Generator_UserColumnName="CreateUser">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="4" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="StartDate" msprop:Generator_ColumnVarNameInTable="columnStartDate" msprop:Generator_ColumnPropNameInRow="StartDate" msprop:Generator_ColumnPropNameInTable="StartDateColumn" msprop:Generator_UserColumnName="StartDate" type="xs:dateTime" />
              <xs:element name="EndDate" msprop:Generator_ColumnVarNameInTable="columnEndDate" msprop:Generator_ColumnPropNameInRow="EndDate" msprop:Generator_ColumnPropNameInTable="EndDateColumn" msprop:Generator_UserColumnName="EndDate" type="xs:dateTime" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="GridAssoc" msprop:Generator_TableClassName="GridAssocDataTable" msprop:Generator_TableVarName="tableGridAssoc" msprop:Generator_TablePropName="GridAssoc" msprop:Generator_RowDeletingName="GridAssocRowDeleting" msprop:Generator_RowChangingName="GridAssocRowChanging" msprop:Generator_RowEvHandlerName="GridAssocRowChangeEventHandler" msprop:Generator_RowDeletedName="GridAssocRowDeleted" msprop:Generator_UserTableName="GridAssoc" msprop:Generator_RowChangedName="GridAssocRowChanged" msprop:Generator_RowEvArgName="GridAssocRowChangeEvent" msprop:Generator_RowClassName="GridAssocRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Assoc" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnAssoc" msprop:Generator_ColumnPropNameInRow="Assoc" msprop:Generator_ColumnPropNameInTable="AssocColumn" msprop:Generator_UserColumnName="Assoc" type="xs:int" minOccurs="0" />
              <xs:element name="ID" msprop:Generator_ColumnVarNameInTable="columnID" msprop:Generator_ColumnPropNameInRow="ID" msprop:Generator_ColumnPropNameInTable="IDColumn" msprop:Generator_UserColumnName="ID">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="40" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Type" msprop:Generator_ColumnVarNameInTable="columnType" msprop:Generator_ColumnPropNameInRow="Type" msprop:Generator_ColumnPropNameInTable="TypeColumn" msprop:Generator_UserColumnName="Type">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Value" msprop:Generator_ColumnVarNameInTable="columnValue" msprop:Generator_ColumnPropNameInRow="Value" msprop:Generator_ColumnPropNameInTable="ValueColumn" msprop:Generator_UserColumnName="Value" type="xs:decimal" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="RoomOccupanciesRadios" msprop:Generator_TableClassName="RoomOccupanciesRadiosDataTable" msprop:Generator_TableVarName="tableRoomOccupanciesRadios" msprop:Generator_RowChangedName="RoomOccupanciesRadiosRowChanged" msprop:Generator_TablePropName="RoomOccupanciesRadios" msprop:Generator_RowDeletingName="RoomOccupanciesRadiosRowDeleting" msprop:Generator_RowChangingName="RoomOccupanciesRadiosRowChanging" msprop:Generator_RowEvHandlerName="RoomOccupanciesRadiosRowChangeEventHandler" msprop:Generator_RowDeletedName="RoomOccupanciesRadiosRowDeleted" msprop:Generator_RowClassName="RoomOccupanciesRadiosRow" msprop:Generator_UserTableName="RoomOccupanciesRadios" msprop:Generator_RowEvArgName="RoomOccupanciesRadiosRowChangeEvent">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="available" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnavailable" msprop:Generator_ColumnPropNameInRow="available" msprop:Generator_ColumnPropNameInTable="availableColumn" msprop:Generator_UserColumnName="available" type="xs:int" minOccurs="0" />
              <xs:element name="total" msprop:Generator_ColumnVarNameInTable="columntotal" msprop:Generator_ColumnPropNameInRow="total" msprop:Generator_ColumnPropNameInTable="totalColumn" msprop:Generator_UserColumnName="total" type="xs:int" />
              <xs:element name="ID" msprop:Generator_ColumnVarNameInTable="columnID" msprop:Generator_ColumnPropNameInRow="ID" msprop:Generator_ColumnPropNameInTable="IDColumn" msprop:Generator_UserColumnName="ID">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="40" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Room" msprop:Generator_ColumnVarNameInTable="columnRoom" msprop:Generator_ColumnPropNameInRow="Room" msprop:Generator_ColumnPropNameInTable="RoomColumn" msprop:Generator_UserColumnName="Room">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="30" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Addresses" />
      <xs:field xpath="mstns:ID" />
    </xs:unique>
    <xs:unique name="Locations_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Locations" />
      <xs:field xpath="mstns:ID" />
    </xs:unique>
    <xs:unique name="LodgingRooms_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:LodgingRooms" />
      <xs:field xpath="mstns:ID" />
    </xs:unique>
    <xs:unique name="Lodgings_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Lodgings" />
      <xs:field xpath="mstns:ID" />
    </xs:unique>
    <xs:unique name="Members_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Members" />
      <xs:field xpath="mstns:ID" />
    </xs:unique>
    <xs:unique name="PositionTypes_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:PositionTypes" />
      <xs:field xpath="mstns:ID" />
    </xs:unique>
    <xs:unique name="RoomTypes_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:RoomTypes" />
      <xs:field xpath="mstns:ID" />
    </xs:unique>
    <xs:unique name="TrainingParticipantPositions_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:TrainingParticipantPositions" />
      <xs:field xpath="mstns:ID" />
    </xs:unique>
    <xs:unique name="TrainingParticipants_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:TrainingParticipants" />
      <xs:field xpath="mstns:Training_ID" />
      <xs:field xpath="mstns:Member_ID" />
      <xs:field xpath="mstns:Position_ID" />
    </xs:unique>
    <xs:unique name="Trainings_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Trainings" />
      <xs:field xpath="mstns:ID" />
    </xs:unique>
    <xs:unique name="TrainingTypes_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:TrainingTypes" />
      <xs:field xpath="mstns:ID" />
    </xs:unique>
    <xs:unique name="Expenses_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Expenses" />
      <xs:field xpath="mstns:ID" />
    </xs:unique>
    <xs:unique name="TrainingParticipants_Expenses_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:TrainingParticipants_Expenses" />
      <xs:field xpath="mstns:ID" />
    </xs:unique>
    <xs:unique name="TrainingRoomOccupancies_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:TrainingRoomOccupancies" />
      <xs:field xpath="mstns:TrainingParticipant_ID" />
      <xs:field xpath="mstns:LodgingRoom_ID" />
    </xs:unique>
    <xs:unique name="GridAssoc_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:GridAssoc" />
      <xs:field xpath="mstns:ID" />
    </xs:unique>
    <xs:unique name="RoomOccupanciesRadios_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:RoomOccupanciesRadios" />
      <xs:field xpath="mstns:ID" />
    </xs:unique>
  </xs:element>
  <xs:annotation>
    <xs:appinfo>
      <msdata:Relationship name="FK_Locations_Lodgings" msdata:parent="Lodgings" msdata:child="Locations" msdata:parentkey="ID" msdata:childkey="Lodging_ID" msprop:Generator_UserChildTable="Locations" msprop:Generator_ChildPropName="GetLocationsRows" msprop:Generator_UserRelationName="FK_Locations_Lodgings" msprop:Generator_ParentPropName="LodgingsRow" msprop:Generator_RelationVarName="relationFK_Locations_Lodgings" msprop:Generator_UserParentTable="Lodgings" />
      <msdata:Relationship name="FK_LodgingRooms_Lodgings" msdata:parent="Lodgings" msdata:child="LodgingRooms" msdata:parentkey="ID" msdata:childkey="Lodging_ID" msprop:Generator_UserChildTable="LodgingRooms" msprop:Generator_ChildPropName="GetLodgingRoomsRows" msprop:Generator_UserRelationName="FK_LodgingRooms_Lodgings" msprop:Generator_ParentPropName="LodgingsRow" msprop:Generator_RelationVarName="relationFK_LodgingRooms_Lodgings" msprop:Generator_UserParentTable="Lodgings" />
      <msdata:Relationship name="FK_LodgingRooms_RoomTypes" msdata:parent="RoomTypes" msdata:child="LodgingRooms" msdata:parentkey="ID" msdata:childkey="RoomType_ID" msprop:Generator_UserChildTable="LodgingRooms" msprop:Generator_ChildPropName="GetLodgingRoomsRows" msprop:Generator_UserRelationName="FK_LodgingRooms_RoomTypes" msprop:Generator_ParentPropName="RoomTypesRow" msprop:Generator_RelationVarName="relationFK_LodgingRooms_RoomTypes" msprop:Generator_UserParentTable="RoomTypes" />
      <msdata:Relationship name="FK_Lodgings_Addresses" msdata:parent="Addresses" msdata:child="Lodgings" msdata:parentkey="ID" msdata:childkey="Address_ID" msprop:Generator_UserChildTable="Lodgings" msprop:Generator_ChildPropName="GetLodgingsRows" msprop:Generator_UserRelationName="FK_Lodgings_Addresses" msprop:Generator_ParentPropName="AddressesRow" msprop:Generator_RelationVarName="relationFK_Lodgings_Addresses" msprop:Generator_UserParentTable="Addresses" />
      <msdata:Relationship name="FK_Members_Addresses" msdata:parent="Addresses" msdata:child="Members" msdata:parentkey="ID" msdata:childkey="Address_ID" msprop:Generator_UserChildTable="Members" msprop:Generator_ChildPropName="GetMembersRows" msprop:Generator_UserRelationName="FK_Members_Addresses" msprop:Generator_ParentPropName="AddressesRow" msprop:Generator_RelationVarName="relationFK_Members_Addresses" msprop:Generator_UserParentTable="Addresses" />
      <msdata:Relationship name="FK_Members_PositionTypes" msdata:parent="PositionTypes" msdata:child="Members" msdata:parentkey="ID" msdata:childkey="PositionType_ID" msprop:Generator_UserChildTable="Members" msprop:Generator_ChildPropName="GetMembersRows" msprop:Generator_UserRelationName="FK_Members_PositionTypes" msprop:Generator_ParentPropName="PositionTypesRow" msprop:Generator_RelationVarName="relationFK_Members_PositionTypes" msprop:Generator_UserParentTable="PositionTypes" />
      <msdata:Relationship name="FK_TrainingParticipants_Members" msdata:parent="Members" msdata:child="TrainingParticipants" msdata:parentkey="ID" msdata:childkey="Member_ID" msprop:Generator_UserChildTable="TrainingParticipants" msprop:Generator_ChildPropName="GetTrainingParticipantsRows" msprop:Generator_UserRelationName="FK_TrainingParticipants_Members" msprop:Generator_ParentPropName="MembersRow" msprop:Generator_RelationVarName="relationFK_TrainingParticipants_Members" msprop:Generator_UserParentTable="Members" />
      <msdata:Relationship name="FK_TrainingParticipants_Positions" msdata:parent="TrainingParticipantPositions" msdata:child="TrainingParticipants" msdata:parentkey="ID" msdata:childkey="Position_ID" msprop:Generator_UserChildTable="TrainingParticipants" msprop:Generator_ChildPropName="GetTrainingParticipantsRows" msprop:Generator_UserRelationName="FK_TrainingParticipants_Positions" msprop:Generator_ParentPropName="TrainingParticipantPositionsRow" msprop:Generator_RelationVarName="relationFK_TrainingParticipants_Positions" msprop:Generator_UserParentTable="TrainingParticipantPositions" />
      <msdata:Relationship name="FK_TrainingParticipants_TrainingParticipants" msdata:parent="Trainings" msdata:child="TrainingParticipants" msdata:parentkey="ID" msdata:childkey="Training_ID" msprop:Generator_UserChildTable="TrainingParticipants" msprop:Generator_ChildPropName="GetTrainingParticipantsRows" msprop:Generator_UserRelationName="FK_TrainingParticipants_TrainingParticipants" msprop:Generator_ParentPropName="TrainingsRow" msprop:Generator_RelationVarName="relationFK_TrainingParticipants_TrainingParticipants" msprop:Generator_UserParentTable="Trainings" />
      <msdata:Relationship name="FK_Trainings_Locations" msdata:parent="Locations" msdata:child="Trainings" msdata:parentkey="ID" msdata:childkey="Location_ID" msprop:Generator_UserChildTable="Trainings" msprop:Generator_ChildPropName="GetTrainingsRows" msprop:Generator_UserRelationName="FK_Trainings_Locations" msprop:Generator_ParentPropName="LocationsRow" msprop:Generator_RelationVarName="relationFK_Trainings_Locations" msprop:Generator_UserParentTable="Locations" />
      <msdata:Relationship name="FK_Trainings_TrainingTypes" msdata:parent="TrainingTypes" msdata:child="Trainings" msdata:parentkey="ID" msdata:childkey="TrainingType_ID" msprop:Generator_UserChildTable="Trainings" msprop:Generator_ChildPropName="GetTrainingsRows" msprop:Generator_UserRelationName="FK_Trainings_TrainingTypes" msprop:Generator_ParentPropName="TrainingTypesRow" msprop:Generator_RelationVarName="relationFK_Trainings_TrainingTypes" msprop:Generator_UserParentTable="TrainingTypes" />
      <msdata:Relationship name="FK_TrainingParticipants-Expenses_TrainingParticipants" msdata:parent="TrainingParticipants" msdata:child="TrainingParticipants_Expenses" msdata:parentkey="ID" msdata:childkey="TrainingParticipant_ID" msprop:Generator_UserChildTable="TrainingParticipants_Expenses" msprop:Generator_ChildPropName="GetTrainingParticipants_ExpensesRows" msprop:Generator_UserRelationName="FK_TrainingParticipants-Expenses_TrainingParticipants" msprop:Generator_RelationVarName="_relationFK_TrainingParticipants_Expenses_TrainingParticipants" msprop:Generator_UserParentTable="TrainingParticipants" msprop:Generator_ParentPropName="TrainingParticipantsRow" />
      <msdata:Relationship name="FK_TrainingRoomOccupancies_LodgingRooms" msdata:parent="LodgingRooms" msdata:child="TrainingRoomOccupancies" msdata:parentkey="ID" msdata:childkey="LodgingRoom_ID" msprop:Generator_UserChildTable="TrainingRoomOccupancies" msprop:Generator_ChildPropName="GetTrainingRoomOccupanciesRows" msprop:Generator_UserRelationName="FK_TrainingRoomOccupancies_LodgingRooms" msprop:Generator_ParentPropName="LodgingRoomsRow" msprop:Generator_RelationVarName="relationFK_TrainingRoomOccupancies_LodgingRooms" msprop:Generator_UserParentTable="LodgingRooms" />
      <msdata:Relationship name="FK_TrainingRoomOccupancies_TrainingParticipants" msdata:parent="TrainingParticipants" msdata:child="TrainingRoomOccupancies" msdata:parentkey="ID" msdata:childkey="TrainingParticipant_ID" msprop:Generator_UserChildTable="TrainingRoomOccupancies" msprop:Generator_ChildPropName="GetTrainingRoomOccupanciesRows" msprop:Generator_UserRelationName="FK_TrainingRoomOccupancies_TrainingParticipants" msprop:Generator_ParentPropName="TrainingParticipantsRow" msprop:Generator_RelationVarName="relationFK_TrainingRoomOccupancies_TrainingParticipants" msprop:Generator_UserParentTable="TrainingParticipants" />
      <msdata:Relationship name="FK_TrainingParticipants_Expenses_Expenses" msdata:parent="Expenses" msdata:child="TrainingParticipants_Expenses" msdata:parentkey="ID" msdata:childkey="Expense_ID" msprop:Generator_UserChildTable="TrainingParticipants_Expenses" msprop:Generator_ChildPropName="GetTrainingParticipants_ExpensesRows" msprop:Generator_UserRelationName="FK_TrainingParticipants_Expenses_Expenses" msprop:Generator_ParentPropName="ExpensesRow" msprop:Generator_RelationVarName="relationFK_TrainingParticipants_Expenses_Expenses" msprop:Generator_UserParentTable="Expenses" />
      <msdata:Relationship name="FK_TrainingParticipants_Expenses_Expenses1" msdata:parent="GridAssoc" msdata:child="TrainingParticipants_Expenses" msdata:parentkey="ID" msdata:childkey="Expense_ID" msprop:Generator_UserChildTable="TrainingParticipants_Expenses" msprop:Generator_ChildPropName="GetTrainingParticipants_ExpensesRows" msprop:Generator_UserRelationName="FK_TrainingParticipants_Expenses_Expenses1" msprop:Generator_RelationVarName="relationFK_TrainingParticipants_Expenses_Expenses1" msprop:Generator_UserParentTable="GridAssoc" msprop:Generator_ParentPropName="GridAssocRow" />
      <msdata:Relationship name="FK_TrainingRoomOccupancies_LodgingRooms1" msdata:parent="RoomOccupanciesRadios" msdata:child="TrainingRoomOccupancies" msdata:parentkey="ID" msdata:childkey="LodgingRoom_ID" msprop:Generator_UserChildTable="TrainingRoomOccupancies" msprop:Generator_ChildPropName="GetTrainingRoomOccupanciesRows" msprop:Generator_UserRelationName="FK_TrainingRoomOccupancies_LodgingRooms1" msprop:Generator_ParentPropName="RoomOccupanciesRadiosRow" msprop:Generator_RelationVarName="relationFK_TrainingRoomOccupancies_LodgingRooms1" msprop:Generator_UserParentTable="RoomOccupanciesRadios" />
    </xs:appinfo>
  </xs:annotation>
</xs:schema>